locked
MDX to DAX Variance Calculations RRS feed

  • Question

  • I have an SSAS cube which i am tryin to rebuilt in BISM Tabular model. I have a simple MDX (see below) which compares sales current period to last period. How can I do the same in DAX.

    ([Date].[Calendar].

    CurrentMember, [Measures].[Sales]) - ([Date].[Calendar].

    CurrentMember.Lag(1), [Measures].[Sales])

     

    Thanks

     

    • Edited by Farrukh Lala Saturday, November 26, 2011 5:13 PM
    Saturday, November 26, 2011 5:10 PM