Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone.
I have a column in Power Query with the "S", "N" and "T" variants. For each of these letters, I have three specific tables and I want to bring a specific column for each one of them. How can I do it?
What I know: if I were not to consider any of these variants, it would be enough to create a custom column whose formula would point to my table that I want to bring. Example: = [T_table]. But what about these three possibilities?
if [Unity] = "S" then [dPropertyUnits] else if [Unity] = "N" then [dUnitPartners] else null returns me error.
Solved! Go to Solution.
Hi @LeandroCampacci ,
You should quote the table column like this when you add a custom column:
= if [Unity] = "S" then #"Table 1"[Group] else if [Unity] = "T" then #"Table 2"[Data] else null
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are you saying you want to bring the whole column from another query and add it as a list to the row?
If so, you have to refer to it by QueryName [column]
At the moment the code is looking for a column called [dPropertyUnits] in the same table - so it won't find it
Yes, the entire column. But it must be selected according to a previous validation [if ...]
Hi @LeandroCampacci ,
You should quote the table column like this when you add a custom column:
= if [Unity] = "S" then #"Table 1"[Group] else if [Unity] = "T" then #"Table 2"[Data] else null
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.