Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyMax Week
Hi good day, Can anyone help me to amend my calculated column, I want my **bleep** Earned Column up to current week only **bleep** Earned = VAR CurrentDate = 'Table#01'[Week No.] ...
bhanu_gautam
Super User
Super UserAllanBerces , Try this
**bleep** Earned =
VAR CurrentWeek = 'Table#01'[Week No.]
VAR CurrentYear = 'Table#01'[Year]
VAR CurrentSubTask = 'Table#01'[Test 2024]
VAR CurrentWeekNum = WEEKNUM(TODAY())
VAR CurrentYearNum = YEAR(TODAY())
VAR FilteredTable = FILTER(
'Table#01',
('Table#01'[Year] < CurrentYearNum) ||
('Table#01'[Year] = CurrentYearNum && 'Table#01'[Week No.] <= CurrentWeekNum) &&
'Table#01'[Test 2024] = CurrentSubTask
)
RETURN
IF(
'Table#01'[Year] < CurrentYearNum ||
('Table#01'[Year] = CurrentYearNum && 'Table#01'[Week No.] <= CurrentWeekNum),
CALCULATE(SUM('Table#01'[Weekly_Earned]), FilteredTable)
)
AllanBerces