Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX get previous values from another DAX

Hi all, 

 

I am new to DAX . So I am trying to build the `DAX Value 2` column. Below is what I am expecting for `DAX Value 2` column. 

For the 'category' C, I want it to be the value of Category B on the measure instead of a running total. 

 

Notes: both the DAX Value 1 and DAX Value 2 will be a Measure instead of from a Table

 

 

Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi,  Anonymous 

    You can try the following steps.

     

    1 Create a Calculated column with Measure DAX Value1

    ColumnFromValue1 = [DAX_Value1]

     

    2 Create a Measure

    Accumulate =

    VAR res =

        CALCULATE (

            SUMX ( 'Table', 'Table'[ColumnFromValue1] ),

            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Index] <= MAX ( 'Table'[Index] ) )

        )

    VAR r1 =

        LOOKUPVALUE ( 'Table'[ColumnFromValue1], 'Table'[Category], "A" )

    VAR r2 =

        LOOKUPVALUE ( 'Table'[ColumnFromValue1], 'Table'[Category], "B" )

    VAR r3 = r1 + r2

    RETURN

    IF ( SELECTEDVALUE ( 'Table'[Category] ) = "C", r3, res )

     

    The result looks like this:

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If not, please consider providing a sample removing sensitive data.

6 Replies

  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago

    first try on the table tools theres a quick measure pane, you can find there a pre defined running total function just specify the parameters field for it and should get you on the road. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      But I am looking to get the previous row value for one specific row, if that make sense. PS: have modified my question above. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Sorry for the confusion. The `DAX Value 2` column is what I am expecting to achieve. Will modify my question right now...

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Updated my post. Let me know if it is still unclear....

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi,  Anonymous 

    You can try the following steps.

     

    1 Create a Calculated column with Measure DAX Value1

    ColumnFromValue1 = [DAX_Value1]

     

    2 Create a Measure

    Accumulate =

    VAR res =

        CALCULATE (

            SUMX ( 'Table', 'Table'[ColumnFromValue1] ),

            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Index] <= MAX ( 'Table'[Index] ) )

        )

    VAR r1 =

        LOOKUPVALUE ( 'Table'[ColumnFromValue1], 'Table'[Category], "A" )

    VAR r2 =

        LOOKUPVALUE ( 'Table'[ColumnFromValue1], 'Table'[Category], "B" )

    VAR r3 = r1 + r2

    RETURN

    IF ( SELECTEDVALUE ( 'Table'[Category] ) = "C", r3, res )

     

    The result looks like this:

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If not, please consider providing a sample removing sensitive data.