Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am working on Dim_Calendar to identify the workday and weekend day and lable them with the month day say (1,2,3,....) from the 1st working day of the month. For example, if the first day of the month starts on sunday (weekend), then the month day should be 0 and should start from the second day (monday) as 1. We should not consider the weekends in between the dates in the month and count the workdays continuously. I have a solution to do this using DAX formula. But I need it to be done in the backend through M Query. Kindly do let me know on the solution.
The solution needed should be as in the below table column D.
Would greatly appreciate any help!
Create a new column
Countx(filter(Date, Date[Is WorkDay] ) , Date[Date])
Hi @amitchandak
Thanks for your response. I would want this column to be created in the backend i.e using m query in query editor.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |