Forum Discussion
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...
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.
