Report number of opened and closed tickets per month

[Cyberfred95]

HI

I am strugling with a very common situation and was not able to found answer in the forum.

I have a table that represents a list of tickets opened in a service center. For each row we have the tichet reference, the opened date and the closed date if the ticket is solved.

Which Power bi model I need to report a graph with opened, closed and still opened tickets ( different between opened and closed) per month ?

Thanks for your help

regards

here is a minimal simple sheet of inial data

SR	Opened date	Closed Date
T1	1-Jan-16
T2	1-Jan-16	1-Feb-16
T3	2-Feb-16	4-Feb-16
T4	3-Mar-16
T5	4-Apr-16
T6	4-Apr-16
T7	4-Apr-16	01-mai-2016
T8	1-May-16	8-May-16

Let me know if you need any other clarification.

Regards. 

[BhaveshPatel]

Need Clarification on this

"Which Power bi model I need to report a graph"

[Cyberfred95]

HI

Sorry for My English. I just wanted to says : How do I need to do with Power Bi desktop to report a chart where I will have on the same chart the number of  tickets created, solved and still opened per month.

Thanks for your help

regards

[BhaveshPatel · Accepted solution]

Hi @Cyberfred95

Check the file at here:

https://drive.google.com/file/d/0B26iWnIZh6PSaWdBTXVKcVZIZlU/view?usp=sharing

I have created a conditional column for finding still opened and closed tickets and for created tickets, I created measure 

Created:=COUNTA(data[SR])

 To visualiza monthly data, I have created a data table and imported into powerbi, Created a relationship with opened date column.

[Anonymous]

Hi @Bhavesh

Please share the pbix file

[kiranrcse]

Hi Bhavesh,

For the same sample data, is there a way to get this output. I am looking for Total Active tickets during that month.

	Total Active	Opened	Closed
Jan	2	2	0
Feb	3	1	2
Mar	2	1	0
Apr	5	3	0
May	6	1	2

Sample Data:

SR	Opened date	Closed Date
T1	1-Jan-16
T2	1-Jan-16	1-Feb-16
T3	2-Feb-16	4-Feb-16
T4	3-Mar-16
T5	4-Apr-16
T6	4-Apr-16
T7	4-Apr-16	1-May-16
T8	1-May-16	8-May-16

Thanks in Advance,

Kiran.

[Cyberfred95]

This looks perfect.

Thanks very much for this

regards