Forum Discussion
jamiefisher
Helper I
Helper IDateTime -DistinctCount on Dates
I have a table with datetime field, I want to add a new measure to show totals per date in a visual and from this I also want a disctinct count on the dates in the table. Help appreciated.
1 Reply
- amitchandak
Super User
jamiefisher , A date column without time, and then you can use that
Date = datevalues([Datetime])
measures
m1= distinctcount(Table[Datetime])
m2= distinctcount(Table[Date])
