Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Time status

Hi all,   I have data that looks like this:     Date Time Status 1899-10-12 02:40:00 M 1899-10-12 02:40:50 M 1899-10-12 02:41:21 X 1899-10-12 02:41:56 X 1899-10-12 0...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi Anonymous

 

One reason could be that there are multiple Status with exact same time

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Zubair_Muhammad,

 

I just checked my dataset and you were correct. There are quite alot of records that have the same time and status, could this perhaps be fixed by transforming "time" to a "date/time" Format ?

 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Hi Anonymous

     

    I am not sure about transforming "time" to a "date/time" Format.

     

    But alternatively,

     

    Instead of RANK calculated Column (which gives us duplicate RANKs due to same times)

     

    We can add an Index Column from Power Query>>AddColumn>>Index Column>>> from 1

    Rename this New Column to RANK

     

    I think then "Previous/Next Status Is X" will work

     

    But your data should be sorted in Ascending Order by time

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Zubair_Muhammad,

     

    Thanks this totally fixed the problem ! everything is working like expected, really like the DAX solution this allows me to keep my filtering options ! 

     

    Best regards,

    L.Meijdam