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.
Trying to create a new column (Market Field2) if the string in column "D" contains "Not assigned" then lookup another little table and compare the Profit center with the profit center in the other little table to get the correct Market field name,
else, if column "D" NOT contain "Not assigned" then return the text in column "D"
The other table looks like this:
Solved! Go to Solution.
Thank you for your help.
I found this solution below
@bgonen , there are few ways you can access of data of other table and then compare it
refer my video for that : https://www.youtube.com/watch?v=czNHt7UXIe8
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 |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |