Forum Discussion
Active Cases by Date
Hey people,
I currently need to count the active legal cases by day using this table:
FACT_CASES ( SK_CASE,SK_CASE_DATE,SK_CLOSED_DATE)
| SK_CASE | SK_CASE_DATE | SK_CLOSED_DATE |
| 1 | 20230101 | 20230201 |
| 2 | 20230201 | 20230225 |
| 3 | 20230301 | 20230326 |
| 4 | 20230302 | 20230324 |
| 5 | 20230325 | 20230411 |
| 6 | 20230415 | NULL |
Desired Output is a matrix table like below:
| Year/Date/Month/Day | Active Cases |
| 20230101 | 1 |
| 20230102 | 1 |
| .. | |
| 20230201 | 1 |
| 20230225 | 0 |
| .. | |
| 20230303 | 2 |
Note: If SK_CLOSED_DATE is null it means case open
Thanks a lot
1 Reply
Anonymous See if this helps: Open Tickets - Microsoft Fabric Community
