Error in date sort from query editor

[Vickchan]

Error is found in date sort from query editor in PowerBI desktop.

As a result, i need to perform sort in descending order in data view.

However, i cannot vlookup date correctly for the sebquence steps.

My data have 56000 rows, would it be the root cause of date sort error in PowerBI desktop? 

pls help

date sort in query editor

Error in date sort in data viewError in date sortCorrect date sort after addiional sort in data view

[ebeery · Accepted solution]

@Vickchan to my knowledge, you cannot (and should not) rely on the sort order of a table loaded into Power BI from Power Query, due to the way the Vertipaq compression works.

See this similar answer here:

https://community.powerbi.com/t5/Desktop/Problem-with-sort-order-changing-after-load-into-model/m-p/... 

I would really recommend you take a different approach here, one that doesn't rely on a sort order for downstream processing.