Forum Discussion

gianmarco's avatar
gianmarco
Helper IV
2 years ago
Solved

Reference a a column for a list in Power Query

Dear All, I have the following table: Table1 CODE VALUE 724 1.000 323 500 null 200 455 300 null 1.200 444 600 256 700   Through the following step in Pow...
Need Help
  • gianmarco's avatar
    gianmarco
    2 years ago

    Dear Ahmedx ,

    it seems that your formula si replacing not only the "nulls" in CODE column but all the elements instead.

    I think I need to change this formula which i'm actually using:

    = Table.TransformColumns( #"previous step", {{"CODE", (x)=> if x = null then List.Select(List.Distinct( #"previous step"[CODE]), each _<> null) else {x}}})

     

    This formula is actually replacing the nulls in code columns with a list of all the CODEs in Code column except null in TABLE1.

gianmarco's avatar
gianmarco
Helper IV
2 years ago

Dear Ahmedx ,

it seems that your formula si replacing not only the "nulls" in CODE column but all the elements instead.

I think I need to change this formula which i'm actually using:

= Table.TransformColumns( #"previous step", {{"CODE", (x)=> if x = null then List.Select(List.Distinct( #"previous step"[CODE]), each _<> null) else {x}}})

 

This formula is actually replacing the nulls in code columns with a list of all the CODEs in Code column except null in TABLE1.

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    it is possible, but my code essentially it only changes null

    • gianmarco's avatar
      gianmarco
      Helper IV
      2 years ago

      Ah, you're right!

      Gonna give it a try, then mark your answer as solution 🙂