Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
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?
It works!!! Thank you so much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |