Forum Discussion

AdamPayne's avatar
AdamPayne
New Member
1 year ago
Solved

Extracting cell value and populating a column, but with criteria to change value

Hi, I've tried searching elsewhere but I'm struggling to find a solution that I follow. Hoping someone on here can help.   In power query I want to populate a new column with a value in column2 and...
Need Help
  • slorin's avatar
    slorin
    1 year ago

    Hi AdamPayne 

     

    =Table.Combine(
       Table.Group(
          Your_Source,
          {"Source.Name"},
          {{"Data", (x) => 
              Table.AddIndexColumn(
                Table.AddColumn(x, "NEW COLUMN", each Text.Combine(x[Column2])),
                "Index", 1),
              type table}}
       )[Data]
    )

    Stéphane 

slorin's avatar
slorin
Icon for Super User rankSuper User
1 year ago

Hi AdamPayne 

 

=Table.Combine(
   Table.Group(
      Your_Source,
      {"Source.Name"},
      {{"Data", (x) => 
          Table.AddIndexColumn(
            Table.AddColumn(x, "NEW COLUMN", each Text.Combine(x[Column2])),
            "Index", 1),
          type table}}
   )[Data]
)

Stéphane 

MCG's avatar
MCG
Icon for Helper I rankHelper I
1 year ago

how about

let
filter=[Source.Name],
result_table=Table.SelectRows(XXX,each [Source.Name]=filter),
result=List.Max(result_table[Column2])
in result

 

change XXX to your source step