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 is the DAX below, which is the cumulative calculated for Sales for each market and it is based on the Days column.

 

RunningSum=

CALCULATE(

SUM( 'TABLE'[sales] ),

FILTER(

ALLSELECTED('TABLE'),

 TABLE'[Market_name]=MAX('TABLE'[market_name]) &&

'TABLE'[Days]>=MAX('TABLE'[Days])))

 

I appreciate any help.

Thanks.

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.

3 Replies

  • 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. 

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    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.