Which values appear more than x days in a month

[amerianou]

Hello everyone,

I've got the following dataset which I have Unpivoted by date and I want to count many values (INDEXes) have more than 5 in's during a month. This will show which are the regular visitors.

Thank you all!

[amitchandak · Accepted solution]

@amerianou , Create a column for month year and then try a measure like

countx(filter(summarize(Table, Table[Index], Table[Month Year], "_1", count(Table[In])),[_1]>5),[Index])

[amerianou]

Hello and thanks for the previous answer, it worked.

But not I have changed my INDEX column from number to text type, because some of my indexes also have letters. That means the summarize function doesn't work. Is there any way to fix this?

thanks in advance!!

[amerianou]

Thank you very much!