Forum Discussion

akim_no's avatar
akim_no
Helper III
7 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.

     

v-hjannapu's avatar
v-hjannapu
Community Support
7 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
7 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.