Forum Discussion

Revilo's avatar
Revilo
Regular Visitor
3 years ago

Column with data separated with semicolon

Hi,   Just want to ask, I have a column in one of my table with format shown below. Is this an array? I am interested in counting rows with blank specific string within that array.   Ex.  I am i...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Revilo 
I hope it is as simple as it is described by the given example. Please let me know if it is not. For now please try

=
COUNTROWS (
    FILTER ( 'Table', NOT CONTAINSSTRING ( 'Table'[Equipment], "followups" ) )
)
  • Revilo's avatar
    Revilo
    Regular Visitor
    3 years ago
    =
COUNTROWS (
    FILTER ( 'Table', NOT CONTAINSSTRING ( 'Table'[Equipment], "followups","appliances", "clothing" ) )
)

    can i add more strings in that parameter like the shown above? thanks