Simple formula to calculate the working day of the month. Edited to handle multiple years.
m_WorkingDayNumberofMonth =
VAR __myDate = MAX([Date])
VAR __tmpTable = FILTER(ADDCOLUMNS(ALL('Calendar'),"__Year",YEAR([Date]),"__Month",MONTH([Date]),"__WeekDay",WEEKDAY([Date],2)),[__WeekDay]<6)
VAR __tmpTable1 = FILTER(__tmpTable,[__Month]=MONTH(__myDate) && [__Year]=YEAR(__myDate))
RETURN IF(WEEKDAY(__myDate,2)>5,BLANK(),COUNTX(FILTER(__tmpTable1,[Date]<=__myDate),[Date]))
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
