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

 

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