Forum Discussion
Solved
Monthly data on closed cases
Hello, I have tried to look at the various ongoing total help but am struggling - any advice gratefully recieved. I have client data with a start date and end date (I have a calendar table as a ...
Sorry I was just putting it as a concept - I think this might explain it better rather than providing random tables (sorry again)
| ID | Start | End |
| 1 | Jan 23 | Feb 23 |
| 2 | Jan 23 | Mar 23 |
| 4 | Feb 23 | |
| 3 | Jan 23 | Jan 23 |
| 5 | Jan 23 | Feb 23 |
Ongoing open cases totals:
Jan 23 = 4
Feb 23 = 4
Mar 23 = 2
ryan_mayu
Super User
Super Userdo not create the relationship between fact table and date table.
pls try this
Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[StartDate]<=max('Table 2'[Date])&&('Table'[EndDate]>=min('Table 2'[Date])||ISBLANK('Table'[EndDate]))))
pls see the attachment below