Forum Discussion
Power ParticipantDisplay Most Recent Date for each Device ID (Ranked)
How can I get it so the table visual only shows 1 one per "Device ID" where the row is the most recent date. I have manged to rank each row for each Device ID, but now stuggling to just get a single row for each Device ID. Hope that makes sence. I dont want the "Ranking" column visible, but its just there for display purposes.
Thanks in advance..
StuartSmith , Use the Rank function as measure and filter on Index Function
Index Function
calculate([Meausre], index(1, allselected(Table[Device], Table[Last Update Date]), orderby(Table[Last Update Date],desc),,partitionBy(Table[Device]) ) )Example of rank
New Rank Desne = rank(DENSE,allselected(Table[Device], Table[Last Update Date]),orderby(Table[Last Update Date],desc),partitionBy(Table[Device]))
2 Replies
- amitchandak
Super User
StuartSmith , Use the Rank function as measure and filter on Index Function
Index Function
calculate([Meausre], index(1, allselected(Table[Device], Table[Last Update Date]), orderby(Table[Last Update Date],desc),,partitionBy(Table[Device]) ) )Example of rank
New Rank Desne = rank(DENSE,allselected(Table[Device], Table[Last Update Date]),orderby(Table[Last Update Date],desc),partitionBy(Table[Device]))
StuartSmithThanks, that worked.