Ben_GFrequent Visitor4 years agoCounting multiple matches Hi. New to this forum so hope my post is clear. I have a table of campaign formats: Format Digital HPP SPP Others I have a table of campaigns which can have 1 or more formats (NB...Show More
FowmySuper User4 years agoBen_G I used Power Query to split the formats, please check the attached file. Counting multiple matches.pbix24 KB
Related contentCounting nullsissue count number of matching values.count values from multiple columnsCount across multiple columnsCount from multiple columns
