Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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.
Thanks - spot on. Appreciate the information.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |