Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |