Forum Discussion
Count values from date
Hi,
I believe this is the result you want. You may download my PBI file from here. I edited the closing date for ID 9 to June 12.
Hope this helps.
Hello Ashish_Mathur
The dates in between should be ignored. My expected result is to get to know how many tickets were opened in a day, and how many were closed in that same day.
So an example:
| ID | Opening Date | Closing Date |
| 1 | 03/06/2018 | 03/06/2018 |
| 2 | 03/06/2018 | 04/06/2018 |
I would want to have a graph showing that I had 2 tickets opened on day 3, and only one closed on that same day, aswell as 0 tickets opened on day 4, and one closed on that same day.
I did a CALCULATE(COUNT(Table1[Opening Date]);Table1[Opening Date]) and a CALCULATE(COUNT(Table1[Closing Date]);Table1[Closing Date]) to count the number of occurences for each date, but when I try to plot the graph, I get mismatched results.
I believe it's a relationship problem. I have a separate date table, and if I relate it to the opening date, I get correct results on the opening date, but wrong results on the closing date. If I relate it to the closing date, I get correct results for the closing date, but wrong results for the opening date.
Any ideas?
Super UserHi,
I believe this is the result you want. You may download my PBI file from here. I edited the closing date for ID 9 to June 12.
Hope this helps.
Yes, that does the trick! Amazing.
I was checking your steps and couldn't understand some of them, like, what's the purpose of the "order" table and some of the steps on the main table. If you ever have some free time would you mind explaning those?
Either way thanks so much for your help! :smileyhappy:
- Ashish_Mathur
You are welcome. The Order Table was created to specify the order of Status as Planned Opened and then closed. Without this table, the graph was first showing Closed and then Open. Please let me know know which other step you are not clear about.