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.
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 |
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
Thanks Nathaniel... that is so perfectly simple when explained 🙂
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |