Forum Discussion
Dynamic Count
Hi all, I need one help for a logic to implement in my PBI I have date_open and date_close in my extract table I need to count active case count based on date_open and date_close The logic ...
There is no information attached.
| ActiveNew | OPEN_DATE | CLOSED_DATE |
| 1 | 3/25/2020 | 5/1/2023 |
| 1 | 6/7/2022 | 5/1/2023 |
| 2 | 7/7/2022 | 5/1/2023 |
| 1 | 8/12/2022 | 5/1/2023 |
| 1 | 8/25/2022 | 5/1/2023 |
| 2 | 9/6/2022 | 5/1/2023 |
| 1 | 9/9/2022 | 5/1/2023 |
| 2 | 9/12/2022 | 5/1/2023 |
| 1 | 9/13/2022 | 5/1/2023 |
| 1 | 9/21/2022 | 5/1/2023 |
| 2 | 10/5/2022 | 5/1/2023 |
| 1 | 11/8/2022 | 5/1/2023 |
| 1 | 11/18/2022 | 5/1/2023 |
| 1 | 12/2/2022 | 5/1/2023 |
| 1 | 12/9/2022 | 5/1/2023 |
| 1 | 1/20/2023 | 5/1/2023 |
| 1 | 2/7/2023 | 5/1/2023 |
| 1 | 3/21/2023 | 5/1/2023 |
| 2 | 3/28/2023 | 5/1/2023 |
| 1 | 4/13/2023 | 5/1/2023 |
| 1 | 4/20/2023 | 5/1/2023 |
| 1 | 7/23/2018 | 5/2/2023 |
| 1 | 3/13/2020 | 5/2/2023 |
| 1 | 9/22/2022 | 5/2/2023 |
| 1 | 9/26/2022 | 5/2/2023 |
| 1 | 10/10/2022 | 5/2/2023 |
| 3 | 10/13/2022 | 5/2/2023 |
| 1 | 10/18/2022 | 5/2/2023 |
| 1 | 10/21/2022 | 5/2/2023 |
| 1 | 10/23/2022 | 5/2/2023 |
| 1 | 10/27/2022 | 5/2/2023 |
| 1 | 10/28/2022 | 5/2/2023 |
| 2 | 10/31/2022 | 5/2/2023 |
| 2 | 11/2/2022 | 5/2/2023 |
| 2 | 11/3/2022 | 5/2/2023 |
| 2 | 11/4/2022 | 5/2/2023 |
| 1 | 11/10/2022 | 5/2/2023 |
| 1 | 11/11/2022 | 5/2/2023 |
| 1 | 11/13/2022 | 5/2/2023 |
| 2 | 11/17/2022 | 5/2/2023 |
| 1 | 11/23/2022 | 5/2/2023 |
| 1 | 11/27/2022 | 5/2/2023 |
| 1 | 11/28/2022 | 5/2/2023 |
| 1 | 12/1/2022 | 5/2/2023 |
| 1 | 12/6/2022 | 5/2/2023 |
| 1 | 12/18/2022 | 5/2/2023 |
| 1 | 1/19/2023 | 5/2/2023 |
| 1 | 1/23/2023 | 5/2/2023 |
| 2 | 1/28/2023 | 5/2/2023 |
| 1 | 2/13/2023 | 5/2/2023 |
| 1 | 2/27/2023 | 5/2/2023 |
| 1 | 3/3/2023 | 5/2/2023 |
| 1 | 3/23/2023 | 5/2/2023 |
| 1 | 3/24/2023 | 5/2/2023 |