Forum Discussion

jamiefisher's avatar
jamiefisher
Icon for Helper I rankHelper I
4 years ago

DateTime -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.  
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

jamiefisher , A date column without time, and then you can use that

 

Date = datevalues([Datetime])

 

 

measures

m1= distinctcount(Table[Datetime])

 

m2= distinctcount(Table[Date])