Find second largest date from multiple columns

[Anonymous]

Hello Community,

As I am new to this community, I would like to find the first, second, third, and last date from multiple columns (4 date columns).  As in excel, it could be obtained from using small and large function.  How to implement the same in Power Bi?

Thanks in advance.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please go to Power Query Editor, add an index column and then unpivot the date columns.

Then refer this post create a rank column.

https://community.powerbi.com/t5/Desktop/Advanced-Rank-in-Power-Query/td-p/2189014 

Best Regards,

Jay

[amitchandak]

@Anonymous , Create a new column

New date =

Minx({[Col1],[Col2],[Col3],[Col4]} ,[Values])

Then create a rank1 on the col

Rank = rankx(Table,[New Date],,asc,dense)

This will rank for the new column, you can smallest, 2nd smallest etc