Power Query-合并的查询返回不正确的结果 [英] Power Query - Merged Query Returning Incorrect Result

问题描述

我有2个表合并到多个字段中，当我预览结果时，它是正确的(排名= 712)，如从此图像中可以看到的那样:

I have 2 tables that are merged on multiple fields, when I preview the result, it is correct (Rank = 712) as can be seen from this image:

但是，当我扩展结果表时，会出现一个不正确的值(等级= 1):

However when I expand the resultant table, an incorrect value (Rank = 1) appears:

以前有没有人看过类似的东西?

Has anyone ever seen something like this before?

推荐答案

如果对排名表进行排序，请找到步骤:排序的行"，然后在Table.Sort之外添加Table.Buffer，例如 Table.Buffer(Table.Sort())，那将是正确的.

If you sorted Ranking table,find step:"Sorted Rows",and add Table.Buffer outside Table.Sort,like Table.Buffer(Table.Sort()),then it will be correct.

这篇关于Power Query-合并的查询返回不正确的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！