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