thangvan114
New Member
- Joined
- Dec 6, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I'm analysing dataset for IT request from Oct-20 to date, sample data as below. I want to analyse the data, and provide dashboard for each month reporting period (end of month): Total request submit in the month (02/21: 4, 03/21: 3), Total request close in the month (02/21: 2, 03/21:3), Overdue request by end of each month (02/21: 2, 03/21:3). Can you please help with the measure formula? Thank you.
Request No | Submit Date | Commit respond date | Respond date | Open Close Status |
1 | 01/02/21 | 14/02/21 | 14/02/21 | Closed |
2 | 02/02/21 | 15/02/21 | 15/02/21 | Closed |
3 | 03/02/21 | 15/02/21 | 15/3/21 | Closed |
4 | 03/02/21 | 15/02/21 | Open | |
5 | 05/02/21 | 16/03/21 | Open | |
6 | 01/03/21 | 14/03/21 | 16/03/21 | Closed |
7 | 02/03/21 | 15/03/21 | Open | |
8 | 03/03/21 | 16/03/21 | 16/03/21 | Closed |