Forum Discussion
Reference a a column for a list in Power Query
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.
write the expected result, it’s not clear what you want
Dear Ahmedx ,
consider I have the following tables:
Table1
CODE VALUE 724 1.000 323
500 null
200 455 300 null 1.200 444 600 256 700 Table2
CODE VALUE 123 100 829
100 047 150 299 300 My expected result is:
replace nulls in table 1 with a list containing the elements of table 2. In this case: {123,829,047,299}
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.