Dynamic Fiscal Year Date Table using DAX in Power BI

[@charlenebowman9112]

Thank you Amelia 🙂

[@nakuldeep7336]

if we have 3 dates columns in order table which datecolumn autocalender pickup

[@prashantparab2482]

Nice Information! How can we calculate Fiscal Year over Year % growth ? example I have 4 Fiscal years to compare % growth in Volumes for more than 300 customers and we have info of volumes for every moth for 4 FY years.

[@PR0SHOTCOAH]

thank you but how would i like this to my other data with the dates?

[@garrettbenson3789]

Fiscal Year =
VAR _CurrYear = YEAR('Fiscal Year Date Table'[Date])
VAR _NextYear = _CurrYear + 1
VAR _PrevYear = _CurrYear -1
VAR CurrYearShort = FORMAT (_CurrYear, "0000")
VAR NextYearShort = FORMAT (_NextYear, "0000")
VAR PrevYearShort = FORMAT (_PrevYear, "0000")
RETURN
SWITCH(
TRUE(),
MONTH('Fiscal Year Date Table'[DATE]) >=4,
CurrYearShort & "-" & NextYearShort,
PrevYearShort & "-" & CurrYearShort
)

[@MohanMohan-zg9mr]

Hello