Forum Discussion
Count multiple text sections in a row with an or statement
Hi community, I'm new to DAX so my question may be very basic :)
I have a large data set similar to the below text. I need to count all the columns that have certain key words.
Example, count all the rows that have the text "office" or "visio". I don't want it to double count rows, such as the first one that has both "office" and "visio". I want that to just be counted as 1.
Thanks in advance for any help.
| Product |
| Office 365, Flow, PowerApps, visio |
| Office 365 |
| Flow, PowerApps |
| Visio, Office 365 |
Hi kduv ,
In Power Query try adding a conditional column. See the picture below. Not sure if a non capitalized word such as "visio" might not have to be another case. Try it. See that I added to Ifs and if there were multiple values, it still gave only 1.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
2 Replies
- Nathaniel_C
Community Champion
Hi kduv ,
In Power Query try adding a conditional column. See the picture below. Not sure if a non capitalized word such as "visio" might not have to be another case. Try it. See that I added to Ifs and if there were multiple values, it still gave only 1.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielThanks Nathaniel... that is so perfectly simple when explained :)
