Aggregating by Date when Time Stamp Present - Please Help!

[Anonymous]

I am putting together a PBI report that tracks usage of a software application.  Each time a user logs in, I receive a date and time stamp.  I have added a column that associates the login with an integer of "1", expecting to sum it in my report. 

I am trying to summarize daily usage and the timestamp is unimportant for my dashboard.

Because of the timestamp, I seem to be prevented from summing the activty to just the date.  I have included a link to a small data sample.  

Existing Result:

3/18/2018 | John Smith | 1

3/18/2018 | John Smith | 1

3/18/2018 | John Smith | 1

3/18/2018 | John Smith | 1

Total                                 4

Desired Result:

3/18/2018 | John Smith | 4

I believe the issue is the time stamp, and me not knowing how to resolve the timestamp, is the issue.

Thanks!

[Greg_Deckler · Accepted solution]

Couple different ways, easiest is to create a new column with a formula of:

Column = DATEVALUE([DateTime])

BTW, you don't need that column with all 1's and 0's in it, just use a COUNT aggregation. 

[Anonymous]

Thanks - spot on.  Appreciate the information.