Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello!
I need a push solving a problem.
I have two tables; Table 1: customer ID and email address; Table 2: supplier ID and email address. I would like to show: IF the same email address is in table 1 and table 2, AND have a customer ID and service ID, show email addresses
Table 1
Customer ID Email Address
334 aa@gmail.com
bb@gmail.com
454 cc@gmail.com
122 dd@gmail.com
ee@gmail.com
678 ff@gmail.com
gg@gmail.com
hh@gmail.com
444 ii@gmail.com
876 jj@gmail.com
444 kkgmail.com
Table 2
Supplier ID Email Address
1113 aa@gmail.com
1112 bb@gmail.com
cc@gmail.com
2345 dd@gmail.com
1111 ee@gmail.com
1000 ff@gmail.com
1100 gg@gmail.com
hh@gmail.com
ii@gmail.com
5678 jj@gmail.com
2000 kkgmail.com
Table 3 - I'm looking for this result (output) Table 3
aa@gmail.com
dd@gmail.com
ff@gmail.com
jj@gmail.com
kkgmail.com
Solved! Go to Solution.
Hi @Nosh10 ,
Try this:
Table = VAR t = FILTER ( CROSSJOIN ( 'Table 1', 'Table 2' ), 'Table 1'[ID Email Address] = 'Table 2'[ID Email Address] && 'Table 1'[Customer] <> BLANK () && 'Table 2'[Supplier] <> BLANK () ) RETURN SELECTCOLUMNS ( t, "Email Address", 'Table 1'[ID Email Address] )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Nosh10 ,
Try this:
Table = VAR t = FILTER ( CROSSJOIN ( 'Table 1', 'Table 2' ), 'Table 1'[ID Email Address] = 'Table 2'[ID Email Address] && 'Table 1'[Customer] <> BLANK () && 'Table 2'[Supplier] <> BLANK () ) RETURN SELECTCOLUMNS ( t, "Email Address", 'Table 1'[ID Email Address] )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |