How to get second, third.. recent date and filtered on individual visual?

Question

In here you see two visual which is a table.&nbsp;I applied the first date&nbsp; by simply using advanced filtered on table A&nbsp; and Top N&nbsp; , value 1.However on table B you can see that i have the first date included along with the second date. is there some way i can get rid of the first date from table B.&nbsp;The reason i am doing this way is that i am constantly refreshing data weekly and want to ensure it display the most recent dates ( first date, second date,third date,etc..) on the separate table across a single page report.Thanks,&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Try to use the RANKX function the get the ranking number. Then filter ranking number as 1, 2 or 3.
Here're some articles talking about the rankx function you can refer to.
Showing Ranking in a Visual in Power BI using RANKX DAX function - RADACAD

RankX Part 1
RankX Part 2
RankX Part 3
RankX and Conditional Formatting in Power BI

&nbsp;
&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

2 Replies

Related content