Forum Discussion
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...
That does not work...same outcome.
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