https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Working-Day-Number-of-Month/m-p/506256#M208 <P>Simple formula to calculate the working day of the month. Edited to handle multiple years.</P> <P>&nbsp;</P> <P>&nbsp;</P> <PRE>m_WorkingDayNumberofMonth = <BR />VAR __myDate = MAX([Date])<BR />VAR __tmpTable = FILTER(ADDCOLUMNS(ALL('Calendar'),"__Year",YEAR([Date]),"__Month",MONTH([Date]),"__WeekDay",WEEKDAY([Date],2)),[__WeekDay]&lt;6)<BR />VAR __tmpTable1 = FILTER(__tmpTable,[__Month]=MONTH(__myDate) &amp;&amp; [__Year]=YEAR(__myDate))<BR />RETURN IF(WEEKDAY(__myDate,2)&gt;5,BLANK(),COUNTX(FILTER(__tmpTable1,[Date]&lt;=__myDate),[Date]))</PRE> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiMzIzNWFjNDEtYTVlMi00NmM1LWIxNzYtNTlkZGYwODBmYjQ0IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Tue, 18 Sep 2018 16:24:14 GMT Greg_Deckler 2018-09-18T16:24:14Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Working-Day-Number-of-Month/m-p/506256#M208 <P>Simple formula to calculate the working day of the month. Edited to handle multiple years.</P> <P>&nbsp;</P> <P>&nbsp;</P> <PRE>m_WorkingDayNumberofMonth = <BR />VAR __myDate = MAX([Date])<BR />VAR __tmpTable = FILTER(ADDCOLUMNS(ALL('Calendar'),"__Year",YEAR([Date]),"__Month",MONTH([Date]),"__WeekDay",WEEKDAY([Date],2)),[__WeekDay]&lt;6)<BR />VAR __tmpTable1 = FILTER(__tmpTable,[__Month]=MONTH(__myDate) &amp;&amp; [__Year]=YEAR(__myDate))<BR />RETURN IF(WEEKDAY(__myDate,2)&gt;5,BLANK(),COUNTX(FILTER(__tmpTable1,[Date]&lt;=__myDate),[Date]))</PRE> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiMzIzNWFjNDEtYTVlMi00NmM1LWIxNzYtNTlkZGYwODBmYjQ0IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Tue, 18 Sep 2018 16:24:14 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Working-Day-Number-of-Month/m-p/506256#M208 Greg_Deckler 2018-09-18T16:24:14Z