DAX - Show latest two column value by Date

[thhmez7]

Hello,

I'd like to create a measure, that show the latest two attributes of the column Type by Date.

So in this example for Brand A, the measure should only show Type = "Red" on April and May. For Brand B it should show Blue in April and Red in May. The attributes can be concatenated or displayed in each row. 

Thank you for your help.

[amitchandak · Accepted solution]

@thhmez7 , if you do not want that based on slicer value, You can use column rank and use that as filter

rank = rankx(filter(Table, [Brand] = earlier([Brand]) ) , [Date],,desc,dense)

filter for <= 2 in a measure of visual level filter

[thhmez7]

Thank you.