Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |