Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |