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

Remove the .[Date] part

wherdzik's avatar
wherdzik
Helper III
2 years ago

That does not work...same outcome.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi wherdzik ,

    Try unchecking Automatic Date/Time. Then create and use the [Month] column in the date table as the axis.

     

    = DISTINCTCOUNTNOBLANK('SEP YTD'[Service Date])

     

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum