Max Week

[AllanBerces]

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.]

                              VAR CurrentSubTask = 'Table#01' [Test 2024]

                              VAR Filteredtable = FILTER('Table#01', 'Table#01' [Week No.]<=CurrentDate && ''Table#01' '[Test 2024] = CurrentSubTask)

                              return

                                 IF(''Table#01' '[Week No.],

                              CALCULATE(SUM(''Table#01' '[Weekly_Earned]), Filteredtable))

Thank you

[bhanu_gautam]

@AllanBerces , 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]

Hi @bhanu_gautam thank you but still the result not the one I required.

Thank you

[bhanu_gautam]

@AllanBerces , Try below mentioned DAX

**bleep** Earned =
VAR CurrentDate = 'Table#01'[Week No.]
VAR CurrentSubTask = 'Table#01'[Test 2024]
VAR Filteredtable = FILTER('Table#01', 'Table#01'[Week No.] <= CurrentDate && 'Table#01'[Test 2024] = CurrentSubTask)

RETURN
IF(
'Table#01'[Week No.] <= CurrentDate,
CALCULATE(SUM('Table#01'[Weekly_Earned]), Filteredtable)
)

[AllanBerces]

HI @bhanu_gautam thank you for the reply but same result. b the way I dont have daily date only Week No. and Year