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 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)
)
AllanBercesPost Prodigy
Post ProdigyHI bhanu_gautam thank you for the reply but same result. b the way I dont have daily date only Week No. and Year