Get previous row value

[Anonymous]

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.

[v-angzheng-msft · Accepted solution]

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]

@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]

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.