Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Can you please review below scenarios and provide your suggestion/s?
I have two tables and both tables are not connceted with any relationship
If table 1 country name column match with table 2 country name then comments should be “DEALER”.
Table 1 (Look Up Table) |
Country Name |
Brazil |
Ecudor |
Peru |
Mexico |
Table 2 | |
Country Name | Comments |
Brazil | Dealer |
Ecudor | Dealer |
Peru |
|
Mexico | Dealer |
Thanks
Solved! Go to Solution.
Hi @tejapowerbi123,
In your sample data the full dataset is on both tables so the result would be Dealer in all rows.
Add the following column to your table 2:
Dealer = IF(LOOKUPVALUE(Table1[Country Name];Table1[Country Name];Table2[Country Name]) <>BLANK() ;"DEALER")
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @tejapowerbi123,
In your sample data the full dataset is on both tables so the result would be Dealer in all rows.
Add the following column to your table 2:
Dealer = IF(LOOKUPVALUE(Table1[Country Name];Table1[Country Name];Table2[Country Name]) <>BLANK() ;"DEALER")
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you so much for quick Response.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |