Forum Discussion
Comparing 2 tables best practice
MasterSonic Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
- MasterSonic4 years ago
Helper IV
Hello, hope this will help.
Basically i would like to build any visual pointing me columns names where values are different for each ID code, between these 2 tables
table1 Id Code OrderNumber Country 101 x20 10877 FR 102 x43 68447 US 103 43 74649 RU 104 x99 5515 FR 105 x55 95 SG 106 78 2156 CZ table 2 Id Code OrderNumber Country 101 x20 10877 UK 104 x43 68447 US 105 43 74649 NL 102 x99 5515 JP 103 x55 95 CN 106 78 216 US 107 88 662 DE