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 da...
Need Help
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.