Forum Discussion

akim_no's avatar
akim_no
Helper III
8 months ago
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...
Need Help
  • akim_no's avatar
    akim_no
    7 months ago

    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's avatar
lbendlin
Super User
8 months ago

REMOVEFILTERS or Window functions should work.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523