Forum Discussion
Pull two most recent dates
I need to pull the two most recent dates or if not two the most recent. Green is what I need to keep.
Hollys83 , Create Rank using rank
Rank 1= Rank(Dense, allselected(Table[HHID], Table[Date]) , Orderby (Table[Date], desc),,PARTITIONBY(Table[HHID]) )
Use a visual-level filter for [Rank 1] <=2
Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo