Distinct Count per Month

[Anonymous]

Hello Guys,

I need some urgent help on a Simple formula on BI.

Have per base the INPUT table (Month is text), I need to do obtain a BI MATRIX with the OUTPUT info and format.

 

Could you please help me on the formula sintax?

Thanks!

[AlB · Accepted solution]

@Anonymous

Just place the month in rows of your matrix and a measure like below in values?

Measure=DISTINCTCOUNT(Table1[AO])