Forum Discussion

wherdzik's avatar
wherdzik
Helper III
2 years ago

Count Distinct Dates Not working

I thought this would work but I am having a hard time to get the service days graph to work.  Esentially I want to be able to count unique service days.  It should be anywhere around 16 to 20 days as...
Need Help
HotChilli's avatar
HotChilli
Community Champion
2 years ago

What is the [Count Days] measure?

wherdzik's avatar
wherdzik
Helper III
2 years ago

I tried Chat GPT and it doesnt like the syntax.

VAR temptable =
    SUMMARIZE (
        FILTER (
            'SEP YTD',
            'SEP YTD'[Service Date] >= FIRSTDATE('SEP YTD'[Service Date]) &&
            'SEP YTD'[Service Date] <= LASTDATE('SEP YTD'[Service Date])
        ),
        'SEP YTD'[Service Date]
    )
RETURN
    COUNTROWS ( temptable )