DAX get previous values from another DAX

[wer1231]

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

[v-cazheng-msft · Accepted solution]

Hi,  @wer1231 

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.

[Ashish_Mathur]

Hi,

What result are you expecting?

[wer1231]

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

[wer1231]

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

[StefanoGrimaldi]

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. 

[wer1231]

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