Know if there are the twelve month of a same year in a bunch of date

[Anonymous]

Hi,

I would like a boolean which give true if there are the twelve different month of the same years in my column DATES if there are not the twelve month it will return false.

Can you help me please?

Thank you!

Have a nice day!

[Greg_Deckler · Accepted solution]

@Anonymous Perhaps something like:

Measure = 
    VAR __Table = ADDCOLUMNS('Dates',"Year",YEAR([Date]),"Month",MONTH([Date]))
    VAR __Table2 = SUMMARIZE(__Table,[Year],"Count",COUNTROWS(DISTINCT(SELECTCOLUMNS(__Table,"Month",[Month]))))
RETURN
    IF(MAXX(__Table2,[Count])=12,1,0)

[Anonymous]

Thank you!