Compare values from different tables

[Anonymous]

Good day!

I have the following tables:

a table called Local containing the columns Local[Cliente] and Local[ProductLocal] - a client can have n products

a table called Global containing the columns Global[Cliente] and Global[ProductGlobal] - a client can have n products

a table called called Clientes containing the column Clientes[Cliente] - not repeated values

The table Clientes creates a join between Local and Global. Product Local and Product Global have different values.

I want to compare Clientes[Cliente] that have a Local[ProductLocal] and Local[ProductGlobal] because the these two tables are populated in a different way. As Product Local and Product Global are different, they are not being allowed to be displayed together in a same table.

Expected result: (the objective is to compare, if there is another away to compare it is ok)

Clientes[Cliente]	Local[ProductLocal]	Local[ProductGlobal]
Cliente A	A	blank
Cliente A	B	blank
Cliente A	C	blank
Cliente A	blank	2
Cliente A	blank	3
Cliente A	blank	4
Cliente B	A	blank
Cliente B	B	blank
Cliente C	C	blank
Cliente D	C	blank
Cliente E	A	blank
Cliente E	blank	1
Cliente E	blank	2
Cliente F	A	blank
Cliente F	B	blank
Cliente F	blank	1
Cliente F	blank	2
Cliente F	blank	3
Cliente G	blank	3
Cliente H	blank	2
Cliente H	blank	3
Cliente I	blank	1

Tables:

Global[Cliente]	Global[ProductGlobal]
Cliente E	1
Cliente E	2
Cliente F	1
Cliente F	2
Cliente F	3
Cliente G	3
Cliente H	2
Cliente H	3
Cliente I	1
Cliente A	2
Cliente A	3
Cliente A	4

Local[Cliente]	Local[ProductLocal]
Cliente A	A
Cliente A	B
Cliente A	C
Cliente B	A
Cliente B	B
Cliente C	C
Cliente D	C
Cliente E	A
Cliente F	A
Cliente F	B

Clientes[Cliente]

Cliente A

Cliente B

Cliente C

Cliente D

Cliente E

Cliente F

Cliente G

Cliente H

Cliente I

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Create a new table:

New Table = 
var _t1= SELECTCOLUMNS('Local',"Client",[Local[Cliente]]],"ProductLocal",[Local[ProductLocal]]],"ProductGlobal",BLANK())
var _t2= SELECTCOLUMNS('Global',"Client",[Global[Cliente]]],"ProductLocal",BLANK(),"ProductGlobal",[Global[ProductGlobal]]])
return UNION(_t1,_t2)

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Boricuanet]

Dear GabrielMonteiro
Maybe this will solve your doubts...

https://community.powerbi.com/t5/Translated-Spanish-Desktop/C%C3%B3mo-comparar-dos-columnas-de-una-t...

https://community.powerbi.com/t5/Translated-Spanish-Desktop/DAX-o-consulta-comparar-dos-columnas-en-...

Best regards