count the number of categories (a single row has multiple categories) in a column

[seemak]

Hi 

Could anyone tell me how to create a column with the count of categories in the highlighted column

100033	Liquid Lounge	1	INR	74.84666	12.87074	Finger Food, Continental, North Indian
100044	Village Restaurant	1	INR	74.85946	12.89898	Chinese, Continental, North Indian, Mughlai

[seemak]

Thank you so much Pete, it worked , but we need to remove the +1

I created the custom column      List.Count(Text.Split([Cuisines],",")) and it worked perfectly

[BA_Pete]

Ah, yes.

I got confused with something else I was doing counting delimiters.

I'll amend my original answer so it's correct for future viewers.

Pete

[BA_Pete · Accepted solution]

Hi @seemak ,

You can try a custom column with the following code:

List.Count(Text.Split([categoryColumn], ","))

Pete