Info from previous row if result was measure

[vrossouw]

Hi

I want to write a measure to find the result from a measure from a previous row, by date and part number.

The SOH column is the result of a measure.

The required result must also be a measure, reading from the previous row, by date and by part.

Spoiler

Part Number	Transaction Date	SOH (measure)	Required result
AA	01 January 2019	32
AA	15 January 2019	55	32
AA	17 January 2019	75	55
AA	04 February 2019	61	75
AA	05 February 2019	51	61
AA	06 February 2019	41	51
BB	06 February 2019	20	0
BB	07 February 2019	20	20

Thank you,

[v-juanli-msft · Accepted solution]

Hi @vrossouw 

Create a calculated column

RANK = RANKX(FILTER('Table','Table'[Part Number]=EARLIER('Table'[Part Number])),[Transaction Date],,ASC,Dense)

Create a measure

Measure 2 = CALCULATE([Measure],FILTER(ALLEXCEPT('Table','Table'[Part Number]),'Table'[RANK]=MAX('Table'[RANK])-1))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vrossouw]

It works perfectly, thank you