Forum Discussion

Helper III

4 years ago

Solved

Count in how many rows a certain substring occours

I have this type of table in Power BI: ID | isPromoter | path | aaa-111-000 | false | sqe-432-w14/2aq-4ec-t66/aaa-111-000/ | sss-342-r34 | true | a3e-543-1sd/34d-245-svt/s3...

fabiomanniti
4 years ago
I figured it out by myself

I added a custom column and this is the code

if [ispromoter] = 1 then List.Count(List.FindText(#"PriorName"[path],[id]))-1 else 0

Helper III

4 years ago

I figured it out by myself

I added a custom column and this is the code

if [ispromoter] = 1
then List.Count(List.FindText(#"PriorName"[path],[id]))-1
else 0

Related content