我想问的是,我有一列索赔,其中有不同发生的索赔,但如果索赔no是不同的,并且第一次发生,然后在重复时指定0,那么是否有任何方法为这个问题创建计算列?
发布于 2022-09-17 10:47:22
您可以使用Power Query来实现您的目标:下面我创建了一些数据集,并获得了一个结果:
假设您有这样的数据集:

下面是Power实现您的目标所涉及的所有步骤。只要将代码粘贴到高级编辑器中,就可以在Home选项卡和查询组中找到:

如果单击“高级编辑器”,可以看到完整的代码,如下所示:

完整的M-代码:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjMwNDFS0lEyVIrVAfNMzYA8IxgPTc4UWQ6s0hBFpSmKnAmKnBGKKcboZsYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Claim No" = _t, Occurances = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Claim No", Int64.Type}, {"Occurances", Int64.Type}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Claim No"}, {{"Order", each _, type table [Claim No=nullable number, Occurances=nullable number]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Order],"SNo",1)),
Custom1 = Table.Combine(#"Added Custom"[Custom]),
#"Added Custom1" = Table.AddColumn(Custom1, "Distinct_Number", each if [SNo] = 1 then 1 else 0),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"SNo"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns",{{"Distinct_Number", Int64.Type}})
in
#"Changed Type1"如果我们测试它,它会返回:

https://stackoverflow.com/questions/73752085
复制相似问题