Forum Discussion
help with power query builder
Hi, this might be really stupid query but i am struggling to get the desired output. I am trying to join two tables. and would like the below output in the resultant table. Table 1 (this table...
Anonymous , the first 2 rows in table 1 are exactly the same. The same is true with table 2. If you join without a unique key data will get duplicated
You can do like:https://radacad.com/append-vs-merge-in-power-bi-and-power-query
If you do not have unique key columns, then you can create common dimensions and analyze them together
Thank you i will try the method in the link.
And yes we do not have unique data in those two table. that is one of the issue. as mentioned table 1 and 2 are actually derived from 2 tables which had unique data.