Triple date sort in Matrix

learner03 , refer to the video on a similar topic

https://www.youtube.com/watch?v=hdEbtlPVWoM

Hi,

I am not sure if I understood your data model correctly.

I assume you have a kind of index column that differenciates a row that has the same information with other row.

Please check the below picture and the attached pbix file.

I created a sort column inside the table, and showed it toghether in a table visualization.

 

 

Sort by condition CC =
IF (
    Data[Date try 1] = BLANK (),
    0,
    RANKX (
        FILTER ( Data, Data[Date try 1] <> BLANK () ),
        INT ( Data[Date try 1] ),
        ,
        DESC
    )
) * 1000000 + Data[Index]
    + IF (
        Data[Date try 2] = BLANK (),
        0,
        RANKX (
            FILTER ( Data, Data[Date try 2] <> BLANK () ),
            INT ( Data[Date try 2] ),
            ,
            DESC
        )
    ) * 10000 + Data[Index]
    + RANKX (
        FILTER ( Data, Data[Date try 3] <> BLANK () ),
        INT ( Data[Date try 3] ),
        ,
        DESC
    ) * 100 + Data[Index]