Forum Discussion
KH_Mike
Helper III
Helper IIICreate new column to check the duplication with certain condition
Hello All, In Power Query, is it possible to create a new column based on below condition? There are "Data Group" either "Revenue" or "Cost". If the "Data Code" under "Data Group" is unique, the...
wdx223_Daniel
Community Champion
Community Champion=Table.Combine(Table.Group(YourTable,{"ID","Data Group"},{"n",each Table.Combine(Table.Group(_,"Data Code",{"t",each let a=Table.RowCount(_) in Table.AddColumn(_,"Checking",each if a=1 then "Y" else if Text.EndsWith([Data Type]," Actual") then "Y" else "N")})[t])})[n])
KH_MikeHelper III
Helper III