Forum Discussion
MTD Working Days
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.
4 Replies
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-Forum/ba-p/963216
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/1447523Easy enough and I always use a separate HOLIDAY table for better readability and maintenance.
There's also this syntax sugar option: NETWORKDAYS function (DAX) - DAX | Microsoft Learn
