Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello community,
I'm stuck on a "simple" problem: In a table, I want to flag rows containing some words comming from a list.
Exemple:
DataTable
Id - Phrase - Flag (Subject of this topic)
1 - I am old - true
2 - I am young - false
3 - I am tall - false
4 - I am tiny - true
...
WordList
blue; big; young; sport; tiny...
Because I have a lot of words in my wordlist, I had created a dedicated table WordList with 1 column containing all words on each rows.
I tryed to use a calculated column in my dataTable but impossible to find the right formula.
Can anyone help me please?
Thank you.
Fabien
Solved! Go to Solution.
Hi @Anonymous ,
here is the solution I propose: create a calculated column in the phrases table with the following formula
Flag = SUMX('Wordlist', IF(ISERROR(SEARCH([Words], 'Phrases'[Phrases])),0,1) )
For each phrase, the formula checks the wordlist and puts 1 if it finds the word and 0 otherwise.
Hope this is what you are looking for!
Regards,
LC
Interested in Power BI dashboards? Check out my blog at www.finance-bi.com
Hi @Anonymous ,
here is the solution I propose: create a calculated column in the phrases table with the following formula
Flag = SUMX('Wordlist', IF(ISERROR(SEARCH([Words], 'Phrases'[Phrases])),0,1) )
For each phrase, the formula checks the wordlist and puts 1 if it finds the word and 0 otherwise.
Hope this is what you are looking for!
Regards,
LC
Interested in Power BI dashboards? Check out my blog at www.finance-bi.com
Thank you very much @lc_finance, it's working perfectly!
I was close but I miss some experience with Power BI 🙂
Have a nice day.
Fabien
Very good to hear that it's working for you!
LC
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |