源 =List.Intersect({Table.ToRecords(chinese),Table.ToRecords(maths)}),

（x,y）=>其中是x是代表“源”，y代表“{1..Table.RowCount(源)-1}”

关键是：List.PositionOf(List.Sort(总分[总分],Order.Descending),[总分])+1

源 =Excel.Workbook(File.Contents("C:UsersAdministratorDesktopPositionOf.xlsx"),null, true),

知识点：each _、List.SortList.Distinct List.PositionOf

= List.ReplaceMatchingItems({1..10},{{1,"a"},{3,"c"}})

= Table.AddColumn(更改的类型, "姓名", each Text.Select([个人信息],{"一".."龟"}))

= Table.Pivot(重排序的列, List.Distinct(重排序的列[类别]), "类别", "姓名",each Text.Combine(_,","))

= Table.AddColumn(源,"国际排名",each Table.RowCount(Table.SelectRows(源,(中娃)=>(中娃)[总分]>[总分]))+1)

数据源