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.
Used for anything related to the new Power BI Desktop and Service tools
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest