Forum Discussion

maggagnon's avatar
maggagnon
Frequent Visitor
3 years ago

Variance to next Fiscal year

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

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi maggagnon ,

     

    Do you have date column in the table?

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