Forum Discussion
FX Rate calculation with a twist
Wait what? Your CashSEK value is not in DKK but in SEK?
hi lbendlin
Thanks alot of the answer and file! I did indeed make an error with my data, sorry! Updated my desired outcome:
Your file does not quite get the right result as it uses the march-rates for all amounts:
But when I make a relation on Date between the Dates and FX tables in your file I gets the correct amounts 👌:
I have an issue when incorporating it into my own file. I need to have 13 period columns which is why I use the period_id instead of months as columns. Period 0 is the previous year carrying over. I cannot use month as columns because 01-01-2024 can be in both period 0 and period 1.
I tried incorporating your solution in my own file which I could not make work:
https://drive.google.com/file/d/1gNn7MqPnd25qSEpukG-c91e72w1SXPH1/view?usp=sharing
How would you approach it if more data was added to your file and you had data in all 13 periods (0 through 12)?
I still don't understand why you would need a crossjoin table. You can do the crossjoin in the visual.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Hi lbendlin
I have made a new post about the issue here (link to sample file included): https://community.fabric.microsoft.com/t5/Desktop/FX-Rate-calculation-works-but-performance-is-poor-Help-me-DAX/m-p/3899172#M1253183If you have time to help me I would greatly appreciate it!
I have marked this as solved, thanks again!