Forum Discussion
Nickster424
Advocate I
Advocate IWeek Number beginning with latest date in my data set
I would like to create a week number column that starts with the latest date in my data table. For example "sales date week ending" is 4/4/2026 and I would like this to be week 1 in the week number ...
Please try the calculated columns below:
Week Number = VAR _LatestDate = CALCULATE ( MAX ( 'Sales'[Sales Date Week Ending] ), ALL ( 'Sales' ) ) RETURN INT ( DIVIDE ( _LatestDate - 'Sales'[Sales Date Week Ending], 7 ) ) + 1 Sales Last 13 Weeks = CALCULATE ( [Total Sales], 'Sales'[Week Number] <= 13 ) Sales Last 4 Weeks = CALCULATE ( [Total Sales], 'Sales'[Week Number] <= 4 )
cengizhanarslan
Super User
Super UserPlease try the calculated columns below:
Week Number =
VAR _LatestDate =
CALCULATE ( MAX ( 'Sales'[Sales Date Week Ending] ), ALL ( 'Sales' ) )
RETURN
INT ( DIVIDE ( _LatestDate - 'Sales'[Sales Date Week Ending], 7 ) ) + 1
Sales Last 13 Weeks =
CALCULATE (
[Total Sales],
'Sales'[Week Number] <= 13
)
Sales Last 4 Weeks =
CALCULATE (
[Total Sales],
'Sales'[Week Number] <= 4
)