Forum Discussion
Solved
Week over Week Diff
Hi, I have a question on a calculation for week-over-week change. I have the data as below: Column 1 is the Week Ending Date Date Name Origin Date Destination Date 6/30/2025 P1 ...
you can try to create three measures
Count of NameTotal = COUNTROWS('Table')Count minus Count of Name with Destination Date = [Count of NameTotal] - CALCULATE(COUNTROWS('Table'),FILTER('Table',not(ISBLANK('Table'[Destination Date]))))Measure =VAR _date = MAX('Table'[Date])VAR _list = CALCULATETABLE(VALUES('Table'[Name]),'Table'[Date] = _date)VAR _list2 = CALCULATETABLE(VALUES('Table'[Name]),FILTER(ALL('Table'),'Table'[Date] < _date))RETURN if (_date=CALCULATE(min('Table'[Date]),all('Table')),0,countrows(EXCEPT(_list, _list2))+0)pls see the attachment below
pls see the attachment below
