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.

     

akim_no's avatar
akim_no
Helper III
8 months ago

v-hjannapu, 

I think it worked for you because you are using a single currency. However, when working with multiple currencies and testing it on my data, it doesn’t work.

Even for the current value — the value of n — it doesn’t give the correct conversion.

In my file, what I’m trying to do is create the following measures ; 

- Euro Amount,

- SelectedRate,

- PY Euro Amount.

For the other ones, however (SelectedRate for test, PY Euro Amount choisen rate, Euro Amount Choisen rate), it allows me to test whether the conversion is applied using the rate I want to use.

 

Thank you 

v-hjannapu's avatar
v-hjannapu
Community Support
8 months ago

Hi akim_no,

As suggested by lbendlin , could you please share the exact sample data? This will help us reproduce the issue on our side and provide the correct answer as per your requirement.

Regards,
Community Support Team.

  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    8 months ago

    Hi akim_no,
    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

    Regards,
    Community Support Team.