Forum Discussion
Conditional column result returns a list – should return a value
My desired result is a returned purchase price of an item that relates to the unique variation number.
I would like to set the condition if fulfilled to pull the relevant data from the connected query, and if it is not met it'll take the data from the active query/table.
As Jimmy801 pointed out since there is no relationships in PQ (which I did not know) I get out the whole list. And only specifying the first row would not solve anything, because 1 row is a unique purchase price per unique item.
Is there any way to solve this in a way I started this out?
I have it solved with merged queries – conditional column – and than deleted the columns I do not need à I just think this is a very inefficient way to go about it…
PhilipTreacy I cannot share the dataset: but it is sales data from the ERP. I want to update past purchase prices since they were not correctly written in the system.
Thanks!
Andraz
Hello apoje
in Power Query you have to join both tables and then expand the column of your joined table. This is how Power Query works
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy