Currency conversion in DAX for Power BI and SSAS
Another interesting question that came up recently is how to do currency conversion in Power BI. My colleague Jeffrey Wang had a very neat solution that I want to share more broadly.
Imagine you have sales in 3 different currencies happening on different dates: