Forum Discussion
Solved
Reference a column from another table in Power Query Editor new column function/query
I want to add a column that counts the number of items that has the foreign ID in one of the corresponding row ID in another table using Power Query Editor and a formula. The formula I improvised is:...
Thanks for the data. That makes it much easier.
I'd probably tackle it with a merge.
See attached PBIX file.
Let me know if you have questions.
Can you please provide some sample (mock-up) data from each of the two tables?
It'll be much easier to help with something to work with.
Device
Zone