how to count occurrences in a field

[Ozymandi4s]

good evening . I need to create a new column that tells me the number of greens that repeats the number 30 for example.

Example: the first record is repeated 4 times the value 30. I need that 4 in a new column

[HotChilli]

Add a new column in Power Query:

List.Count (Text.PositionOf ([total_sizes],"30",Occurrence.All))

[amitchandak]

@Ozymandi4s , One of the way is count is

New column in power query

List.Count(Text.Split([Column], ",")) +1

Once you so Text.Split, you can do other List operations too

https://docs.microsoft.com/en-us/powerquery-m/list-functions

[Ozymandi4s]

I need a way to count without adding columns

[amitchandak]

@Ozymandi4s , one of the best way is to split this column into rows, but that will increase the size of the table

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[Ozymandi4s]

I need a way to count without adding columns