Previous fiscal year values based on selected fiscal year slicer and completed month in selected FY

[Anonymous]

Hello All,
I have a requiment where I am looking for Previous fiscal year values based on selected fiscal year slicer and completed month in selected FY.

Selected slicer 2023-24  and Month completed till oct 2023
Previous year slicer 2022-23 
 Fiscal year start month is April of every year

Like I have selected 2023-24 from slicer and I need previous year total sales for growth % calcualtion based on current fiscal year completed months.

Completed month = Apr 23 to Oct 23 

Required PY sales month for fiscal 2022-23 is Apr 22 to Oct 22 

I have a calender table as but I have created FY column in my base table itself using M query.


I am looking for Total sale values based on above condition.


Thanks
Dean

[Anonymous]

@Uzi2019  Yes That has been taken care already.

Thanks
Dean

[Uzi2019]

Hi @Anonymous 

You can simply create the following measure
Prev year= CALCULATE(Sum( Total sales),DATEADD( 'Fiscal date',-1, Year))

this will give you previous year sales if your year fiter is from April 2023 upto Oct 2023 then Prev Year data will be from april 2022 till oct 2022.

If I answered your question please give kudos and accept it as a solution!

Thanks

[Uzi2019]

Hi @Anonymous 
Did you create fiscal calendar table??
Your fiscal year should be properly mapped to April - March month.