Forum Discussion

Joao_C_Faria's avatar
Joao_C_Faria
Helper I
4 years ago
Solved

DAX(COUNTROWS)

Good morning,
I have this DAX formula, 
 
 COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR('Produção'[DataINICIO],'Produção'[DataFIM]),"WORKDAY",if(WEEKDAY([Date],2) >=6,0,1)),[WORKDAY]=1))
 
but I need to add some Saturdays where the company has open, how I do IT?


Thanks,compliments.
 
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    To identify those saturdays when the company is open, you would need a flag as a separate column and then you can use that in your measure.

    Instead of Workday = 1, it would be CompanyOpenDay=1

3 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    To identify those saturdays when the company is open, you would need a flag as a separate column and then you can use that in your measure.

    Instead of Workday = 1, it would be CompanyOpenDay=1