Ranking values in power query are reversed after merging two queries

[Anonymous]

In Power Query, I tried to create a ranking for location ID's based on a date. For this, I firstly sorted the location ID's based on the date. Subsequently I grouped all location ID's and created a custom column in order to add a ranking for each location ID.

Then, a new column is displayed with a correct ranking (most recent date has ranking value 1, most recent but one has value 2, then 3, etc.)

After merging the newly created column with another table, the ranking values are suddenly in reversed order. This means that the oldest date has ranking value 1, the oldest but one has value 2, then 3, etc.

It seems that a bug occurs during the query merge, which results in reversed ranking values.

The ranking as it should be:

 The ranking after having merged 2 queries. The column [RankLastVisit] has a reversed value order:

[v-yetao1-msft]

Hi @Anonymous 

I tried to recreate the scenario you described, but failed. Can you provide your pbix file for reference(remove sensitive info) ?

Best Regards,
Community Support Team _ Ailsa Tao

[Anonymous]

Hi @v-yetao1-msft ,

Please find the pbix file and excel data sources in the link below:
https://we.tl/t-QPlOR51PX1

Kind regards,
Jonas