Forum Discussion

Killingworth's avatar
Killingworth
Regular Visitor
6 years ago
Solved

Working Days

I have two tables   1. With raw data of interactions broken down by date   2. Date table with all dates of the year with an indicator if the day is a working day or not.   I have a measure whic...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Killingworth 

     

    please try this

    THISMONTHWORKDAY = 
CALCULATE(COUNTROWS('DATE'),FILTER('DATE','DATE'[Date]<=TODAY()&&'DATE'[WORKDAY2]="WEEKDAY"))

     

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

Killingworth 

 

please try this

THISMONTHWORKDAY = 
CALCULATE(COUNTROWS('DATE'),FILTER('DATE','DATE'[Date]<=TODAY()&&'DATE'[WORKDAY2]="WEEKDAY"))

 

Killingworth's avatar
Killingworth
Regular Visitor
6 years ago

That worked thanks for your help