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.
Hello everyone,
I am trying to get the last "Aprt_estado" of the last date from this articles. On this example, for my filter of February 2020, I I woud like to see for the ESAP_COD 81029, only 28/02/20 and aprt estado= ET. That's it. If move out the column "aprt_estado", my measure will show the correct last date (28/02) but I need that information.
Any advice? thanks a lot!!
Solved! Go to Solution.
Hi @okusai3000 ,
Based on your description, you can do some steps as follows.
index =
RANKX (
FILTER ('CASE2',
'CASE2'[esca_cod]=EARLIER('CASE2'[esca_cod])),
'CASE2'[Ultimo Mov].[Date],
,DESC
)
Measure = CALCULATE(MAX('CASE2'[esca_cod]),'CASE2'[index]=1)
Result:
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @okusai3000 ,
Based on your description, you can do some steps as follows.
index =
RANKX (
FILTER ('CASE2',
'CASE2'[esca_cod]=EARLIER('CASE2'[esca_cod])),
'CASE2'[Ultimo Mov].[Date],
,DESC
)
Measure = CALCULATE(MAX('CASE2'[esca_cod]),'CASE2'[index]=1)
Result:
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@okusai3000 , add new measures like
lastnonblankvalue(table[Ultimo Mov] ,max(Table[Aprt_estado]))
lastnonblankvalue(table[Ultimo Mov] ,max(Table[Cant Equipos V2]))
hi @amitchandak ,
The problem is that *Ultimo Mov is not a column... is a Measure, so I cannot use it on lastnonblankvalue... any other idea?
thanks!
BTW, this is [ultimo mov]
EDIT.
Ok, finally solved with a part of what @amitchandak said,
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |