It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

MDX vs. DAX: Currency Conversion Faceoff

Compare and contrast how multidimensional and tabular achieve the same end result in quite different ways. Learn where multidimensional decorates the metadata of the model, while tabular offloads responsibility to DAX. Understand how the design goals of the DAX language – which are akin to Excel formulas and relational-database concepts – differ from MDX and traditional OLAP. Features covered can be used in a broad range of scenarios (not only currency conversion), adding valuable knowledge to your SSAS arsenal.

Christian Wade, creator of the BISM Normalizer, has been doing BI and solution architecture since SQL Server 7. He spoke at the PASS Community Summit in 2012 and 2005, the 2005 European PASS Conference, and other events including SQLSaturday.