Pull two most recent dates

[Hollys83]

I need to pull the two most recent dates or if not two the most recent. Green is what I need to keep. 

[Ashish_Mathur]

Hi,

If you want a Power Query solution, then share data in a format that can be pasted in an MS Excel file.

[amitchandak]

@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