Show most 5 recent records based on date and team name

[jhubert41]

Hello, I am looking to get the following output on the right. On the left is the original dataset. Bascially I am looking to filter my data to show the most 5 recent dates grouped by team name. Any help is appreciated! 

[Ashish_Mathur]

Hi,

Create a slicer of Away and select ANA.  to your Table visual, drag Home and write these measures

Date value = sum(Data[Date])

Top 5 = calculate([Date value]),topn(5,all(Data[Home]),[Date value]),values(Data[Home]))

Drag the Top 5 measure to the visual.  

[v-yiruan-msft · Accepted solution]

Hi @jhubert41 ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

1. Create a measure as below:

Flag = 
VAR _selaway =
    SELECTEDVALUE ( 'Table'[Away] )
VAR _rank =
    RANKX (
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Away] = _selaway ),
        CALCULATE ( MAX ( 'Table'[Date] ) ),
        ,
        DESC,
        DENSE
    )
RETURN
    IF ( _rank <= 5, 1, 0 )

2. Create a table visual and apply the visual-level filter with the condition(Flag is 1)

Best Regards