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 )