Revenue PY in Financial year (not Calendar year)

[U2Hiro]

Hi All,

I wanna calculate Revenue PY (Previoius Year) with dax formula, so please give me your idea.

With calendar data, I understand we can calculate revenue in previous year with following formula

- Revenue PY = CALCULATE( [Revenue] , SAMEPERIODLASTYEAR( 'Date_mapping'[Date] ))

But I wanna calculate same as above with Financial year metrics. Financial year doesn't align with auto created year by Power BI so I prepared date mapping aside from original revenue data.

I'm considering to use 'Year ID', which means (Revenue PY in FY22) should be pulled from {(Year ID of FY22) -1} .

Here is my out put image

Thanks in advance.

Hiro

[v-shex-msft · Accepted solution]

Hi @U2Hiro,

I'd like to suggest you use current fiscal date to find out correspond date ranges. Then you can transform these date values to get correspond previous date range and use it as condition to calculate.

Regards,

Xiaoxin Sheng