Forum Discussion
Helper IDesign a DBA Dashboard
@JIblasco - You can create a selector for this
Selection selector for selection options
VAR __Max MAXX (ALL('Table'),[timestamp])
Return
IF(MAX('Table'[timestamp]) at __Max,1,0)
See Complex Selector - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
Also, maybe Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
Hi , JIblasco
As mentioned by amitchandak ,please create a calculated column:
Rank = RANKX(FILTER(ALL('Table'),'Table'[KPI ]=EARLIER('Table'[KPI ])),'Table'[timestamp],,DESC)And applied it to filter pane:
Best Regards,
Community Support Team _ Eason
Super UserJIblasco , Take these two measures along with KPI in you visual
new timestamp = lastnonblank(table[timestamp],blank())
new Value = lastnonblankvalue(table[timestamp],max(Table[Value]))
Or create a Rank of time inside KPI and filter on 1
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
JIblascoHi,
Thank you for your quick response. I have decided to create a view in the database with the las timestamp of each KPI. Anyway, thank you for the rank refers.