Having trouble retrieving the previous value

[Renef92]

Hello all, 

My goal is to get to the previous value from my price column; based on the date downloaded column. I've added an index and have calculated the previous index using the selected index. 

The problem is that my previous price measure is returning the same value. Any ideas?

Prev Index =

var Ind = SELECTEDVALUE(Sheet1[Index])

var previn = CALCULATE(MAX(Sheet1[Index]), FILTER(ALL(Sheet1), Sheet1[Index] < Ind))

return

previn

Previous Price =

var Ind = SELECTEDVALUE(Sheet1[Index])

var previn = CALCULATE(MAX(Sheet1[Index]), FILTER(ALL(Sheet1), Sheet1[Index] < Ind))

return

CALCULATE(SUM(Sheet1[Price]), FILTER(Sheet1, previn)

)

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Renef92]

https://drive.google.com/file/d/1W4UAE7glhF4wwWgpuIsV-I3iAo3umDb2/view?usp=sharing

Link to download PBIX

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Renef92]

Thank you, this worked perfectly. 

[Ashish_Mathur]

You are welcome.

[Renef92]

I added a more appropriate pic.