Forum Discussion
Max 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.]
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
4 Replies
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)
)HI bhanu_gautam thank you for the reply but same result. b the way I dont have daily date only Week No. and Year
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)
)
