Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get previous row value

  I need to get previous row value (Result column) and need help. I tried DAX but its only giving me partial result. The values should be previous rows taken from MyMeasure1.  My measure 1 i...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

     

    An optional option:
    Step 1: Create an index column (you can add an index column through the UI in PowerQuery)
    Step 2: Create the following measure

     

    _getResult = 
var _currentIndex=MAX('Table'[Index])
return 
CALCULATE([My measure1 as Measure],FILTER(ALL('Table'),'Table'[Index]=_currentIndex-1))
////Assuming [My measure1 as Measure] is your measure1

     

    Result:

    Please refer to the attachment below for details. Hope this helps.

     

    If this doesn't work for you, please consider sharing a sample.

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tahreem24's avatar
Tahreem24
Super User
4 years ago

Anonymous , Create a measure like this:

Prev Row Measure =
VAR res_ = CALCULATE([Running Sum Measure],FILTER(

ALLSELECTED('TABLE'),TABLE'[Market_name]=MAX('TABLE'[market_name]) &&'TABLE'[Days]>MAX('TABLE'[Days])))
RETURN IF(res_=BLANK(),[Running Sum Measure],res_)

 

I tried with some dummy data at my side:

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the help, but it didnt work.

    I did the same DAX but the result I get is not correct, you get different result maybe beacuse you dont have addiitonal grouping in your data for the Days column.