Forum Discussion
Post ProdigySum of Week
Hi good day,
Can someone pls need your help on my measure , I have a table and i want to calculate the sum of Wk from WK 01 to 46 and another is from WK 1 to 47, then the following WK will be WK 01 to 47 and other in WK01 to 48 and so on. Can some edit correct my measure.
Thank you
Hi AllanBerces - you can use a measure that adjusts the sum based on the current context.
ceate a measure for Sum from Week 01 to Current Week
Sum_Wk01_to_CurrentWeek =
VAR CurrentWeek = MAX('Table'[WeekNo])
RETURN
CALCULATE(
SUM('Table'[HRs]),
FILTER(
ALL('Table'),
'Table'[WeekNo] <= CurrentWeek &&
'Table'[Year] = MAX('Table'[Year])
)
)Try the first measure and for previous week for week 46 you can also use below:
Sum_Wk01_to_LastWeek =
VAR CurrentWeek = MAX('Table'[WeekNo])
RETURN
CALCULATE(
SUM('Table'[HRs]),
FILTER(
ALL('Table'),
'Table'[WeekNo] <= CurrentWeek - 1 &&
'Table'[Year] = MAX('Table'[Year])
)
)Hope this works. please check
1 Reply
- rajendraongole1
Super User
Hi AllanBerces - you can use a measure that adjusts the sum based on the current context.
ceate a measure for Sum from Week 01 to Current Week
Sum_Wk01_to_CurrentWeek =
VAR CurrentWeek = MAX('Table'[WeekNo])
RETURN
CALCULATE(
SUM('Table'[HRs]),
FILTER(
ALL('Table'),
'Table'[WeekNo] <= CurrentWeek &&
'Table'[Year] = MAX('Table'[Year])
)
)Try the first measure and for previous week for week 46 you can also use below:
Sum_Wk01_to_LastWeek =
VAR CurrentWeek = MAX('Table'[WeekNo])
RETURN
CALCULATE(
SUM('Table'[HRs]),
FILTER(
ALL('Table'),
'Table'[WeekNo] <= CurrentWeek - 1 &&
'Table'[Year] = MAX('Table'[Year])
)
)Hope this works. please check