MTD Working Days

[Jagat]

hi there,

need help to create the "MTD Working Days" which also work on the "Month" slicer.

I have "Holiday Master" with date & status columns. Status column contains "Holiday" or "Working".

For example: last month(June), I had 24 working days & in current month(July), I have 23 working days.

so if my month slicer is on June then "MTD Working Days" return 24 as on today all June working days are passed but if month slicer is on July then it must return the number of working days till yesterday.

Kindly help me on that.

[ThxAlot]

Easy enough and I always use a separate HOLIDAY table for better readability and maintenance.

MTD Networkday.pbix

[lbendlin]

There's also this syntax sugar option:  NETWORKDAYS function (DAX) - DAX | Microsoft Learn

[ThxAlot · Accepted solution]

Aha, thx for the tip! I'm still dwelling on the old-school formulas.

MTD Networkday.pbix

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...