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 Power BI Community,
I have 2 tables in my pbix file - 1 as the main source data, the other is the lookup values and correspoding category.
I want to return the "Category" Column to the main source by using "Standard Reason" Column as the look up values to main source data "Text line 4" Column.
Lookup Value
Main Source
So, if "Text line 4" contains words from the list of "Standard Reason", it will return the "Category".
Thank you in advance!
Solved! Go to Solution.
Hi @rosemilo
this a very similar case https://community.powerbi.com/t5/DAX-Commands-and-Tips/Convert-Excel-formula-to-DAX-Measure/m-p/2587...
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 |
---|---|
38 | |
26 | |
20 | |
15 | |
8 |
User | Count |
---|---|
69 | |
47 | |
46 | |
20 | |
16 |