I have a trending table and here is a sample data
My goal is to find the "Key" that has COUNT>1 in the latest date i.e. Key=1 should be outputed since it appeard twice in 3/1/2019
My logic is to create a calculated column
1- First filter the table to only inlcude latest date records
2- Use Earlier function to get the ones that has more than one records in that filtered table
Go to Solution.
If there's only one key with count > 1 for the last date, you can create a measure and place it in a card visual:
DISTINCT ( Table1[Key] ),
CALCULATE ( COUNT ( Table1[Key] ) ) > 1 && Table1[Date] = MAX ( Table1[Date] )
Please mark the question solved when done and consider giving kudos if posts are helpful.
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!