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
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.