hi
let me begain by saying , im not a power BI pro ( to say the least 🙂 )
i have a cases table
| Number | Opened | Domain | Group | Assigned to | State | Substate | Customer Priority | First Response Time | Resolved | Closed | Channel | Internal Priority |
| CS0054154 | 2020-03-30 08:39:59 | Smart | HD - Help Desk | Racheli Maman | Cancelled | | 3 - Low | 2020-03-30 08:46:09 | | 2020-03-30 09:10:44 | Phone | 3 – Low |
| CS0054150 | 2020-03-30 08:30:56 | Smart | HD - Help Desk | Tzlil Ben-Naeh | Resolved | | 3 - Low | 2020-03-30 08:38:32 | 2020-03-30 10:47:50 | | Phone | 3 – Low |
| CS0054149 | 2020-03-30 08:28:18 | Smart | HD - Help Desk | Eliran Giladi | Resolved | | 3 - Low | 2020-03-30 08:37:39 | 2020-03-30 10:50:14 | | Phone | 3 – Low |
| CS0054148 | 2020-03-30 08:22:48 | Smart | HD - Help Desk | Eliran Giladi | Resolved | | 3 - Low | 2020-03-30 08:25:56 | 2020-03-31 11:20:26 | | Phone | 3 – Low |
| CS0054147 | 2020-03-30 08:20:01 | Smart | HD - Help Desk | Lior Nisim | Resolved | | 1 - Critical | 2020-03-30 08:25:33 | 2020-03-30 09:56:20 | | Phone | 1 – Critical |
| CS0054146 | 2020-03-30 08:13:51 | Smart | HD - Help Desk | Racheli Maman | Resolved | | 3 - Low | 2020-03-30 08:15:36 | 2020-03-30 17:51:47 | | Phone | 3 – Low |
| CS0054145 | 2020-03-30 07:58:17 | Smart | HD - Help Desk | Lior Nisim | Resolved | | 3 - Low | 2020-03-30 08:08:01 | 2020-03-30 08:11:33 | | Phone | 3 – Low |
| CS0054141 | 2020-03-30 07:40:57 | Smart | HD - Help Desk | Eliran Giladi | Resolved | | 3 - Low | 2020-03-30 07:45:33 | 2020-03-30 10:41:40 | | Phone | 3 – Low |
| CS0054138 | 2020-03-30 07:38:59 | Smart | HD - Help Desk | Tzlil Ben-Naeh | Resolved | | 3 - Low | 2020-03-30 07:49:08 | 2020-03-30 10:47:20 | | Phone | 3 – Low |
| CS0054128 | 2020-03-29 17:16:25 | Smart | HD - Help Desk | Lior Nisim | Closed | | 3 - Low | 2020-03-29 18:01:03 | 2020-03-30 14:33:56 | 2020-04-01 13:49:44 | Web | 3 – Low |
| CS0054124 | 2020-03-29 16:44:17 | Smart | HD - Help Desk | Racheli Maman | Open | Analysis | 3 - Low | 2020-03-29 16:47:24 | | | Phone | 3 – Low |
| CS0054100 | 2020-03-29 15:18:30 | Smart | HD - Help Desk | Lior Nisim | Closed | | 3 - Low | 2020-03-29 15:22:31 | 2020-03-29 15:27:10 | 2020-04-01 04:00:07 | Phone | 3 – Low |
| CS0054098 | 2020-03-29 15:17:22 | Smart | HD - Help Desk | Bill Sadkovets | Resolved | | 2 - High | 2020-03-29 15:31:26 | 2020-03-30 11:38:56 | | Web | 2 – High |
| CS0054089 | 2020-03-29 14:29:38 | Smart | HD - Help Desk | Tzlil Ben-Naeh | Closed | | 3 - Low | 2020-03-29 14:32:12 | 2020-03-29 14:39:14 | 2020-04-01 04:00:06 | Phone | 3 – Low |
| CS0054086 | 2020-03-29 14:15:13 | Smart | HD - Help Desk | Lior Nisim | Closed | | 3 - Low | 2020-03-29 14:24:28 | 2020-03-29 14:30:10 | 2020-04-01 04:00:01 | Phone | 3 – Low |
| CS0054084 | 2020-03-29 14:12:48 | Smart | HD - Help Desk | Tzlil Ben-Naeh | Closed | | 3 - Low | 2020-03-29 14:15:17 | 2020-03-29 14:38:47 | 2020-04-01 04:00:07 | Phone | 3 – Low |
| CS0054077 | 2020-03-29 13:58:52 | Smart | HD - Help Desk | Lior Nisim | Closed | | 3 - Low | 2020-03-29 14:10:56 | 2020-03-29 14:52:22 | 2020-04-01 04:00:04 | Web | 3 – Low |
| CS0054069 | 2020-03-29 13:39:07 | Smart | HD - Help Desk | Bill Sadkovets | Closed | | 3 - Low | 2020-03-29 13:40:29 | 2020-03-29 15:00:29 | 2020-04-01 04:00:04 | Web | 3 – Low |
im trying to create a table that will hold data for each day like the sum of the cases of that were opend on that day and the sum of the cases that was resolved that day. in order to calculate this
date, ( count opened ) - (count resolved) = daily backlog, in the next day i will add the "daily backlog" to (count opend )
for example 1/1/2019 ( count opend = 50) - (count resolved= 30) = 50-30 = daily backlog= 20
2/1/2019 (count opend = 25 + ( daily backlog of yesterday =20 )=45 - (count resolved =40) = daily backlog= 5
i hope i made any sence with my explanation
thanks
