Hello friends,
I'm currently in the process of calculating the Delta between the Budget for 2024 and the Forecast for 2023. The SAC-Model provides a measure called "Amount," and the data for both the Budget and Forecast are stored in separate versions.
To achieve this, I've established three distinct measures:
Budget 24: This measure involves applying filters for the Budget version and the date of 2024, with Constant Selection enabled.
FC 23: In this measure, I've applied filters for the Forecast version and the date of 2023, again with Constant Selection enabled.
Delta: The Delta measure is obtained by subtracting the Budget 24 measure from the FC 23 measure.
However, the outcome is rather perplexing. While the Year column provides the accurate value, all the monthly values appear to be the same. This issue is clearly visible in the attached screenshot:

How can I get the correct Delta Values on monthly Basis?.
Thank you for your assistance.
Kind regards,
Ismail