Getting the Distinct Values of A Shared Field from Two Different Tables

Used for anything related to the new Power BI Desktop and Service tools
Harry
Posts: 1
Joined: Thu May 21, 2020 4:52 pm

Getting the Distinct Values of A Shared Field from Two Different Tables

Postby Harry » Thu May 21, 2020 4:54 pm

Hi everyone,

I have two tables; Table A and Table B, which share a common field – Business Unit.
I want to create a new table that contains all of the distinct business units that exist in either Table A or Table B.

To date, I have used the Values() function but this has only given me the distinct values in ONE table. There may be scenarios where a particular business unit occurs in table A and not table B or vice versa so I need a solution that will be robust enough to handle this.

Any ideas?
Thanks!

Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 0 guests