Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have been trying to figure something out for a few days now.
I used the following solution to get current workday of the month here as "Institutional.CurrentWorkDay".
Institutional.CurrentWorkDay = IF('Date'[Institutional.WorkDay]=0, BLANK(), CALCULATE( SUM('Date'[Institutional.WorkDay]), ALLEXCEPT('Date', 'Date'[Calendar Month Name],'Date'[Calendar Year]), 'Date'[Day] <=EARLIER('Date'[Day]) ) )
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"?
If I were you I would maintain that information in your Dates table. So much easier than trying to do it in code.