Forum Discussion

Shaiksamar2244's avatar
Shaiksamar2244
Frequent Visitor
2 years ago
Solved

Row by Row condition

Hello Everyone,   Could someone please assist me with this?   ERP system is not picking up created from for all requests. I have given the output I'm looking for.   The created form should be f...
Need Help
  • Shaiksamar2244's avatar
    Shaiksamar2244
    2 years ago

    Hi Stephane,

     

    I'm not sure why I'm getting this, Could you please help me on this?

     

     

slorin's avatar
slorin
Super User
2 years ago

Hi, 

let
Source = YourSource
Group = Table.Group(Source, {"Document Number"}, 
     {{"Created From", each Text.Combine(List.Distinct([Created From]))}, 
      {"Amount", each [Amount]}}),
Expand = Table.ExpandListColumn(Group, "Amount")
in
Expand

Stéphane