Date time sort not work in correct order

[Anonymous]

Hi Experts

having some trouble sorting my data out using the index against the datetime column. it may appear to be correct but if you look at the date time values cearfully they are out of sink.

https://www.dropbox.com/s/agucoa2nxjy4txh/plot.pbix?dl=0 

[v-yadongf-msft]

Hi @Anonymous ,

Can you describe in detail your problem you're having ? Or tell me the result you want?

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Community Support - i want the datetime column to be sorted as per the index column based on datetime column. so all the data points are in the correct order. if you scroll down the datetime column you can see that further down we have 20/11/2022 01:00:00 when they all should be all together.

PREVIEW

[Ahmedx]

maybe so  Column = RANKX(ALL(Sheet1),'Sheet1'[CalculationTimeUTC],,ASC)

[Anonymous]

Hi Ahmedx - try it and see if you can sort the datetime column please.

[Ahmedx]

You have duplicates in the column CalculationTimeUTC , you need to remove them. and then in power queue sort and create an index column

Please check attached pbix for more details

https://dropmefiles.com/xzxjW

[Anonymous]

The dups need to remain as they are real data points in the datetime timeline plot...