Forum Discussion

Girish_123's avatar
Girish_123
Icon for Helper I rankHelper I
3 years ago

group the value wherever is break

Hi Team, I have a one column want to create new column problem is whenereve there is value other than one make it in a new group  how to achive the result in power query or dax calculation below is ...
Need Help
Show and Tell
Tips and Tricks
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    g = Table.Group(Source, "Input Column", {{"all", each _}}, GroupKind.Local, (s, c) => Number.From(c <> 1)),
    idx = Table.AddIndexColumn(g, "Output Column", 1, 1),
    prefix = Table.TransformColumns(idx, {"Output Column", each "G" & Text.From(_)}),
    r = Table.RemoveColumns(prefix,{"Input Column"}),
    e = Table.ExpandTableColumn(r, "all", {"Input Column"})
in
    e