Forum Discussion
Solved
Keeping a fixed conversion rate while comparing current and previous year
I have a semantic model where my fact table is linked to my calendar table by date. I use a month/year slicer to allow the user to select a single month and year (e.g., November 2025). Based on th...
In the end, to avoid the rate being impacted by SAMEPERIODLASTYEAR, I first calculate the PY amount in local currency. Then I apply the conversion, instead of relying on the already converted amount and using time intelligence functions. This approach fixes the issue.
lbendlin , A PBIX file is available at the link below to explain this case in more detail :
https://github.com/akimno/power-bi/blob/main/order_test.pbix
Thanx