Variance to next Fiscal year

[maggagnon]

Hi,

I am calculating the difference between 2 numbers for a fiscal year

2022-2023

Total Rocks = 10

Total Apples = 6

Variance = 4

I would like the variance to only appear under variance in the next fiscal year and not any other. 

2023-2024

Total Rocks = 0

Total Apples = 0

Variance = 4

So far I have this : 

Variance = CALCULATe([Total Rocks]-[Total Apples ],(filter(all('Fiscal Year'),'Fiscal Year'[Fiscal Year]="2022-2023")))

How can I then apply the measure to report the value for next fiscal year only.

Thanks

[v-jayw-msft]

Hi @maggagnon ,

Do you have date column in the table?

Please share some sample data so that we could test the formula.