Forum Discussion

kduv's avatar
kduv
New Member
7 years ago
Solved

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 a...
  • Nathaniel_C's avatar
    Nathaniel_C
    7 years ago

    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

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

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

kduv's avatar
kduv
New Member
6 years ago

Thanks Nathaniel... that is so perfectly simple when explained :)