Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Workday count in M Query

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!

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous ,

     

    Create a new column

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.