Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Ezhilmathi
Frequent Visitor

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.

Ezhilmathi_0-1674826798245.png

 

Would greatly appreciate any help!

 

2 REPLIES 2
amitchandak
Super User
Super User

@Ezhilmathi ,

 

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.