Workday count in M Query

[Ezhilmathi]

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!

[amitchandak]

@Ezhilmathi ,

Create a new column

Countx(filter(Date, Date[Is WorkDay] ) , Date[Date])

[Ezhilmathi]

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.