Currency Conversion in Tabular Model Using DAX

Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the Leaves function in MDX). I documented the implementation in a few blog posts:

• Currency Conversion Using Measure Expressions
• Currency Conversion Using MDX Leaves Function

I have now also implemented currency conversion in a tabular cube using DAX. This blog post covers the implementation in DAX as well as some of the performance issues I encountered and how I resolved them.

Read more...