Forum Discussion
Create bar chart for gap between two count value per month
Hi,
I would like to make a bar chart showing the value of (count of closed - count of open) per month. Can you give me suggestion on how I put measure for this? Below table is the example of the data:
| Notification | Date | Status |
| AAAA | 04/01/2020 | Closed |
| BBBB | 02/04/2020 | Closed |
| CCCC | 18/06/2020 | Open |
| DDDD | 01/01/2020 | Closed |
| EEEE | 05/12/2020 | Open |
| FFFF | 06/01/2020 | Closed |
| GGGG | 07/08/2020 | Closed |
| HHHH | 08/08/2020 | Open |
| IIII | 09/08/2020 | Open |
| JJJJ | 10/08/2020 | Open |
| KKKK | 11/08/2020 | Closed |
| LLLL | 12/05/2020 | Open |
| MMMM | 13/11/2020 | Closed |
| NNNN | 15/03/2020 | Closed |
Thank you for your help.
Regards,
Vano
Anonymous , Try a measure like
calculate(count(Table[Notification]), filter(Table, Table[Status]="Closed")) -calculate(count(Table[Notification]), filter(Table, Table[Status]="Open"))
2 Replies
Anonymous , Try a measure like
calculate(count(Table[Notification]), filter(Table, Table[Status]="Closed")) -calculate(count(Table[Notification]), filter(Table, Table[Status]="Open"))
Anonymous