Forum Discussion
Aggregating by Date when Time Stamp Present - Please Help!
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!
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.
2 Replies
- Greg_Deckler
Community Champion
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.