Forum Discussion
cumulative count
Good, hoping you are well.
I would like to know how I can generate a cumulative measure, I have two tables, one of users with the date on which they registered and another of the calendar, I would like to know how I can count and accumulate to see the increase of users per day based on the calendar table, example:
Users table:
| User | Register | Loud |
| Usuario1 | 1 | 01/01/2021 |
| usuario2 | 1 | 01/05/2021 |
| usuario3 | 1 | 01/03/2021 |
Calendar table:
| Date | Month | week | Day |
| 01/01/2021 | 1 | 1 | 1 |
| 02/01/2021 | 1 | 1 | 2 |
| 03/01/2021 | 1 | 1 | 3 |
| 04/01/2021 | 1 | 1 | 4 |
| 05/01/2021 | 1 | 1 | 5 |
| 06/01/2021 | 1 | 1 | 6 |
| 07/01/2021 | 1 | 1 | 7 |
| 08/01/2021 | 1 | 2 | 1 |
| 09/01/2021 | 1 | 2 | 2 |
Matrix to be generated:
| 01/01/2021 | 02/01/2021 | 03/01/2021 | 04/01/2021 | 05/01/2021 | 06/01/2021 | 07/01/2021 |
| 1 | 1 | 2 | 2 | 3 | 3 | 3 |
I tried the following but it goes wrong:
Thank you in advance.
Best regards
1 Reply
Syndicate_Admin , measure seem fine. Make sure calendar is connected agent on the date.
Try one of the two
CALCULATE(SUM(agent[Register]),
FILTER(
ALLSELECTED(Calendar[Date]),Calendar[Date]< = MAX(Calendar[Date])))or
CALCULATE(SUM(agent[Register]),
FILTER(
ALL(Calendar[Date]),Calendar[Date]< = MAX(Calendar[Date])))
