Real Working Days

DAX DAX Calculations
2

Hello @cms418,

Thank You for posting your query onto the Forum.

Create a calculated column in your table with the below provided formula -

Real Work Days - Harsh = 
CALCULATE( COUNTROWS( 'Date Table' ) , 
    DATESBETWEEN(
        'Date Table'[Date] , 
        'Plannning and Progress Tracker'[Actual Mobilization Start Date] , 
        'Plannning and Progress Tracker'[Actual Demobilization End Date] ) , 
    'Date Table'[DayOfWeekName] <> "Sunday" ,
    ALLSELECTED( 'Plannning and Progress Tracker' ) )

Below is the screenshot of the final results provided for the reference -

Final Results
Final Results1051×683 39 KB

I’m also attaching the working of the PBIX file for the reference purposes as well as providing the link below of the articles as well as videos available onto this very similar topic which was created by our EDNA expert @BrianJ.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Date Stuff3.pbix (3.6 MB)

1 Like