Combine values of two tables

[naufal_msr]

Hi,

I have two tables of different sources with no relationship created. Here is sample of my data :

Table A

Brand	SKU	Retail Price
A	ABC0001	20
A	ABC0002	10
A	ABC0003	30

Table B

Brand	SKU	Retail Price
B	BCD001	25.50
C	DEF001	10.50

My goal is to create a visual where we can compare the retail price by brand, of which where most of the SKUs are located at. So the legend will be "Brand", Axis will be "Retail Price", and Values will be "Count of SKU".

Is there a way for me to achieve this ?

Thanks !

Regards

Naufal

[Greg_Deckler]

@naufal_msr I would highly recommend that you Append those two tables in Power Query or use UNION to combine them in DAX. Then it is trivial.

[naufal_msr]

I probably should've mentioned that the tables have much more columns which are unrelated to each other. Is there a way for me to grab only these three particular columns out of tens of others ? If im not mistaken both append queries and UNION will require to have same columns for both tables. Please advise.

Thanks ! @Greg_Deckler