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.
Hello
I have 2 tables:
Table 1 include grocery store names in a city and its addresses:
Grocery store names | Address |
Small region 1 Walmarts | Street A 1 |
491801 Small region 2 Target | Street B 1 |
Table 2 include small regions and big region names:
Small Region | Big Region |
Small region 1 | Big region 1 |
Small region 2 | Big region 2 |
I want to make a new column in Table 1 that is:
if Table1[Grocery store names] contains Table2[Small Region] then Table1[Address] & Table2[Small Region] & Table2[Big Region]
else Table1[Address]
Sample outcome table:
Grocery store names | Address | New column |
Small region 1 Walmarts | Street A 1 | Street A 1 Small region 1 Big Region 1 |
How can I achieve this?
Thank you before hand!
Solved! Go to Solution.
I found solution in this post: https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/m-p/182148#M79842
I found solution in this post: https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/m-p/182148#M79842
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |