https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Maximum-working-day-per-month/m-p/1918467#M41575 <LI-CODE lang="csharp">[Monthly Max Business Day] = // calculated column var CurrentMonth = T[Month] var CurrentYear = T[Year] var MonthlyMaxBusinessDay = MAXX( filter( T, T[Month] = CurrentMonth &amp;&amp; T[Year] = CurrentYear &amp;&amp; T[Business Day] = 1 ), T[Date] ) return MonthlyMaxBusinessDay</LI-CODE> Wed, 23 Jun 2021 21:42:22 GMT daxer-almighty 2021-06-23T21:42:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Maximum-working-day-per-month/m-p/1918391#M41573 <P>Hello Team,<BR /><BR />I am working with my calendar table and&nbsp;I need to enter the maximum day worked per month. I integrated a holiday data table in my data model and with that I get the Wordays column this month, but I am having a problem adding a column with the maximum day per month.<BR /><BR />thank a lot!<BR /><BR /><img /></P> Wed, 23 Jun 2021 20:00:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Maximum-working-day-per-month/m-p/1918391#M41573 Joshua_ 2021-06-23T20:00:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Maximum-working-day-per-month/m-p/1918467#M41575 <LI-CODE lang="csharp">[Monthly Max Business Day] = // calculated column var CurrentMonth = T[Month] var CurrentYear = T[Year] var MonthlyMaxBusinessDay = MAXX( filter( T, T[Month] = CurrentMonth &amp;&amp; T[Year] = CurrentYear &amp;&amp; T[Business Day] = 1 ), T[Date] ) return MonthlyMaxBusinessDay</LI-CODE> Wed, 23 Jun 2021 21:42:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Maximum-working-day-per-month/m-p/1918467#M41575 daxer-almighty 2021-06-23T21:42:22Z