Real Working Days

DAX DAX Calculations
1

Date Stuff3.pbix (3.6 MB)
Hi there,

  • Trying to calculate the ‘Real Work Days’ in between MOB and DEMOB (Omitting Sundays)

  • I set up a calculated column with a switch statement (In the Date table) to isolate if the day is weekday or weekend. Also have a a couple ways to show the calendar days, as you’ll see.

  • However, the ‘Real Work Days’ measure is showing me the same results for both ‘Calendar Day’ methods.

image

Can you guys help me out?

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
3

Thank you Harsh

4

Hello @cms418,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh

1 Like