Forum Discussion
Help with Currency Conversion, Need to have Fixed Rate and Transaction Rate
I tried a different approach and it works well for handling transactions across different dates. The idea is to use time intelligence to shift the transactions while keeping the rate difference (fixed vs transaction) as a constant. This way, the transactions convert according to the desired date logic, and the rate difference variable simply determines whether the calculation uses the fixed rate or the transaction rate
Thanks FBergamaschi for breaking down this information.
The solution provided by AI was split into two variables and force the rate. Just confirming there isn't a way to just shift context of transactions but keep the rate.
Super UserHI HinW12
so are the nrs shown the correct ones? If not, which is wrong, so we fix it?
Best
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
The rates are correct but when I write a previous year value the filters change. I have thought of another approach which I will share.