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 ...
do 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
