I'm trying to get the previous row value of a dynamic measure but all the queries I try so far didn't work.
DynamicMeasure = IF(SELECTEDVALUE( MainMeasureSlicer[Display As])="Revenue"| SUM(Pipeline[TotalValue])| DISTINCTCOUNT(VwFaturamento[Id]) )
Previous DynamicMeasure = VAR prevrank = CALCULATE ( MAX([DynamicMeasure])| FILTER ( Bridge| Bridge[Rank] < EARLIER(Bridge[Rank]|1) ) ) RETURN IF (ISBLANK (prevrank)|BLANK() | prevrank )
Can anyone help me, please?
Any help would be very appreciated,
Hi @Thássia ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.