Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Find second largest date from multiple columns

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.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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