Max值所在的月份

shufeabb

最大值所在的月份.zip (6.91 KB, 下载次数: 10)

2023-5-7 08:23 上传

点击文件名下载附件

my0745

1. let
   
2.     源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
   
3.     s1 = Table.RemoveColumns(Table.Group(源,"c1",{"data",each Table.AddColumn(_,"m",(x)=> Table.Max(_,"c3")[c2])}),"c1"),
   
4.     exp = Table.ExpandTableColumn(s1, "data", {"c1", "c2", "c3", "m"}, {"c1", "c2", "c3", "m"}),
   
5.     cha = Table.TransformColumnTypes(exp,{{"c2", type date}, {"m", type date}})
   
6. in
   
7.     cha

复制代码

万事胜①

1. let
   
2.     源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
   
3.     分组的行 = Table.Combine(Table.Group(源, "Custom Field  7", {"计数",each Table.AddColumn(_,"月份",(x)=> _{Table.PositionOf(_,Table.Max(_,each [Acquisition]))}[#"Placed-in-Service Date"])})[计数])
   
4. in
   
5.     分组的行

复制代码

maoxiong1999

=Table.AddColumn(源,"最大值月份",each Table.Group(源,"Custom Field  7",{"t",each Table.Max(_,"Acquisition")}){[Custom Field  7=[Custom Field  7]]}[t][#"Placed-in-Service Date"])