Get previous row value of a dynamic measure

[Anonymous]

Hi people,

I'm trying to get the previous row value of a dynamic measure but all the queries I try so far didn't work.

Dynamic measure

DynamicMeasure = IF(SELECTEDVALUE( MainMeasureSlicer[Display As])="Revenue"|
  SUM(Pipeline[TotalValue])|
  DISTINCTCOUNT(VwFaturamento[Id])
 )

Previous Measure

Previous DynamicMeasure = 
VAR prevrank =
    CALCULATE (
        MAX([DynamicMeasure])|
        FILTER ( Bridge| Bridge[Rank] < EARLIER(Bridge[Rank]|1) )
    )
RETURN
    IF (ISBLANK (prevrank)|BLANK() | prevrank )

Error message

Goal

Can anyone help me, please?

Any help would be very appreciated,

Thanks! 

[Anonymous]

I'm trying to get the previous row value of a dynamic measure but all the queries I try so far didn't work.

Dynamic measure

DynamicMeasure = IF(SELECTEDVALUE( MainMeasureSlicer[Display As])="Revenue"|
  SUM(Pipeline[TotalValue])|
  DISTINCTCOUNT(VwFaturamento[Id])
 )

Previous Measure

Previous DynamicMeasure = 
VAR prevrank =
    CALCULATE (
        MAX([DynamicMeasure])|
        FILTER ( Bridge| Bridge[Rank] < EARLIER(Bridge[Rank]|1) )
    )
RETURN
    IF (ISBLANK (prevrank)|BLANK() | prevrank )

Error message

Goal

Can anyone help me, please?

Any help would be very appreciated,

Thanks! 

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

If [rank] is a column and tables have correct relationships to connect data, 

create a measure as below

Measure = CALCULATE([dynamic Measure],FILTER(ALLSELECTED(Sheet8),[rank]=MAX(Sheet8[rank])-1))

If the measure doesn't work on your side, please share an example data and relationships among these tables.

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.

[NanaPsych]

Hi @v-juanli-msft ,

In my case, rank is a column, but it is a time data-type. What can I do in that case?

[Anonymous]

It works!!! Thank you so much!