Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Distinct Count per Month

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!

  • Anonymous

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

    Measure=DISTINCTCOUNT(Table1[AO])

1 Reply

  • AlB's avatar
    AlB
    Community Champion

    Anonymous

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

    Measure=DISTINCTCOUNT(Table1[AO])