Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |