Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Problems calculating cumulative records based on date

Estimad@s, I would like to express my concern about a problem that has arisen for me.

For context I have a database where each record (row) gives me information about a ticket or request, these tickets or requests have a date of creation and a date of resolution (if the ticket or request was resolved, it is emptied otherwise).

AlexisCab1602_0-1629298497005.png

This database is connected to a calendar table where the "Date" column of the "Calendar" table is related to the "Creation Time" column (which would be the equivalent of resolution date in the example above) of the "report_service_f" table,

AlexisCab1602_1-1629298733938.png

What I need is to count according to the days of the month/year how many tickets were created, how many were resolved and how many were pending (accumulated).

example based on the information provided above:

AlexisCab1602_2-1629299140470.png

I'm new to the DAX language and that's why I haven't been able to solve this problem which is perhaps easy. I would very much appreciate your help.