Week over week measure
Hi, I have created this "# Open tickets EOP" measure and it is working and looks like this below: OpenTasksWoW = VAR MinDate = MIN ( 'dim_date'[Date] ) VAR MaxDate = MAX ( 'dim_date'[Date] ) VAR Result = CALCULATE ( COUNTROWS ( CurrentRow_tasks ), CurrentRow_tasks[taskCreatedDateDK] <= MaxDate, OR( CurrentRow_tasks[taskClosedDateDK] > MinDate, ISBLANK(CurrentRow_tasks[taskClosedDateDK]) ), REMOVEFILTERS ( 'dim_date' ) ) RETURN Result # Open tickets EOP = CALCULATE ( [OpenTasksWoW], LASTDATE ( 'dim_date'[Date] ) ) But now I also want to calculate the days the ticket is open week over week. This measure is not working because it shows only a value for the first week a ticket is open. DaysOpen = VAR CreatedDate = MAX(CurrentRow_tasks[taskCreatedDateDK]) VAR ClosedDate = MAX(CurrentRow_tasks[taskClosedDateDK]) VAR LastDateInPeriod = LASTDATE('dim_date'[Date]) RETURN IF( ISBLANK(ClosedDate), DATEDIFF(CreatedDate, LastDateInPeriod, DAY), IF( ClosedDate <= LastDateInPeriod, DATEDIFF(CreatedDate, ClosedDate, DAY), DATEDIFF(CreatedDate, LastDateInPeriod, DAY) ) ) I want a value for EVERY week a ticket is open. So for every end of period it should calculate the days it is open. In this example: INCIDENT798633 should have value 11 for Year_Week_Numeric = 202506, value 18 for Year_Week_Numeric = 202507, value 25 for Year_Week_Numeric = 202508, etc.
