Get the previous value with non-date column

[Anonymous]

Hi team,

I need a help in getting "only" the previous row value.  In the below image, "Prev" calculating cumulative. How do i modify it to show only the previous value without cumulative total.

[Anonymous · Accepted solution]

I updated my measure "Prev" as below which worked.

Prev =

var a = CALCULATE(MAX('Dynamic Date Scope'[ranking]))+1

Return CALCULATE(SUM(Volume[Record ID]),FILTER(ALLSELECTED('Dynamic Date Scope'),'Dynamic Date Scope'[ranking]=a))

Ranking is the column that i created in the Dataset itself while querying from DB.

[amitchandak]

@Anonymous , Create a new table with distinct VD1 (FY Month) , Period and ranking

Rank should be same as

Rank = rankx(period, [VD1], ,asc, dense)

The create measures like

This Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL("Period"),"Period"[Period Rank]=max("Period"[Period Rank])))
Last Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL("Period"),"Period"[Period Rank]=max("Period"[Period Rank])-1))

[Anonymous]

@amitchandak Thanks Amit.

I will try this method. Thanks for helping me on this.