Forum Discussion

Andries_Benade's avatar
Andries_Benade
New Member
3 years ago
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:...
Need Help
  • KNP's avatar
    KNP
    3 years ago

    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.

     

KNP's avatar
KNP
Super User
3 years ago

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.