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 ...
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