Forum Discussion
Solved
FX Rate calculation with a twist
I am building a balance sheet statement that I need to convert to USD. I have manipulated my data in a way that it always calculates the YTD amount depending on the column in the matrix. Now I need t...
Wait what? Your CashSEK value is not in DKK but in SEK?
lbendlin
Super User
Super UserI 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#M1253183
If you have time to help me I would greatly appreciate it!
I have marked this as solved, thanks again!