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.
2 Replies
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
Hi,
If you want a Power Query solution, then share data in a format that can be pasted in an MS Excel file.
