Calculate Distinct count of Days within a month

[Sab]

Hello,

I need to calculate distinctcount of days within a month in a datetime column, it may be easy but I am not having any luck!

So if this column has data for say 10 days of Feb and 15 days of March, the measure should show:

Month            Result

Feb                 10

Mar                15

[MFelix · Accepted solution]

Hi @Sab ,

Try the following measure:

Distintcount =
VAR temptable =
    GROUPBY (
        SUMMARIZE (
            'Table';
            'Table'[Timestamp];
            "@date"; FORMAT ( 'Table'[Timestamp]; "dd/mm/yyyy" )
        );
        [@date]
    )
RETURN
    COUNTROWS ( temptable )

[Sab]

Thanks Miguel!