https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Day-of-the-Fiscal-Year-DAX/m-p/1632875#M33093 <P>If I were you I would maintain that information in your Dates table. So much easier than trying to do it in code.</P> Sat, 30 Jan 2021 00:46:47 GMT lbendlin 2021-01-30T00:46:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Day-of-the-Fiscal-Year-DAX/m-p/1632487#M33078 <P><SPAN>I have been trying to figure something out for a few days now.&nbsp;</SPAN></P><P><SPAN>I used the following solution to get current workday of the month here as "Institutional.CurrentWorkDay".</SPAN></P><P>&nbsp;</P><P><SPAN>Institutional.CurrentWorkDay = IF('Date'[Institutional.WorkDay]=0, BLANK(), CALCULATE( SUM('Date'[Institutional.WorkDay]), ALLEXCEPT('Date', 'Date'[Calendar Month Name],'Date'[Calendar Year]), 'Date'[Day] &lt;=EARLIER('Date'[Day]) ) )</SPAN></P><P>&nbsp;</P><P><SPAN>How would I edit the formula to get workday of the fiscal year? Or is there a better way to write the sequence of "day of the fiscal year"?&nbsp;</SPAN></P><P><SPAN><img /></SPAN></P> Fri, 29 Jan 2021 18:49:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Day-of-the-Fiscal-Year-DAX/m-p/1632487#M33078 TAMOREIRA 2021-01-29T18:49:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Day-of-the-Fiscal-Year-DAX/m-p/1632875#M33093 <P>If I were you I would maintain that information in your Dates table. So much easier than trying to do it in code.</P> Sat, 30 Jan 2021 00:46:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Current-Day-of-the-Fiscal-Year-DAX/m-p/1632875#M33093 lbendlin 2021-01-30T00:46:47Z