Forum Discussion
What would be the exact formula for this count function?
Hi, I want to come up with a formula which aggregrates the number of creation times per person based on one day. The column index is just 1. The second image shows that the...
- Anonymouscreate a calcualted columncountfunction = CALCULATE(SUM(Table1[Index]), ALLEXCEPT(Table1, Table1[User Name], Table1[CreationTimeUTC.1]))
Anonymous please provide the data in text format not an image
Hi vanessafvg,
Sure, here it is.
| CreationTimeUTC.1 | User Name | Index |
| 8/1/2018 0:00 | B | 1 |
| 8/1/2018 0:00 | B | 1 |
| 8/1/2018 0:00 | B | 1 |
| 8/1/2018 0:00 | B | 1 |
| 8/1/2018 0:00 | B | 1 |
| 11/26/2018 0:00 | D | 1 |
| 11/26/2018 0:00 | D | 1 |
| 11/26/2018 0:00 | D | 1 |
| 1/16/2019 0:00 | D | 1 |
| 1/16/2019 0:00 | D | 1 |
| 3/20/2019 0:00 | D | 1 |
- Anonymouscreate a calcualted columncountfunction = CALCULATE(SUM(Table1[Index]), ALLEXCEPT(Table1, Table1[User Name], Table1[CreationTimeUTC.1]))
Thank you! This worked.