Problems calculating cumulative records based on date

[Syndicate_Admin]

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).

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,

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:

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.

[ryan_mayu · Accepted solution]

@Syndicate_Admin 

pls see the attachment below

[Syndicate_Admin]

Thank you so much for your help, you don't know how much I tried to do !!!!!!!!!! 😁😁

[ryan_mayu]

you are welcome