Forum Discussion
Solved
SUM Weekly
Hi good day, Can anyone pls need help on my table for the new new column to get the SUM of PT pls refer below. Thank you
Hi nandic thank you for your reply, i got the solution on my problem.
SUM_PT =
SUMX (
FILTER (
SUMMARIZECOLUMNS (
'Table01'[Trade],
'Table01'[Week No.],
'Table01'[PT]
),
'Table01'[DPR_DATE] = EARLIER ( 'Table01'[DPR_DATE] )
&& 'Table01'[Trade] = EARLIER ( 'Table01'[Trade] )
&& 'Table01'[Week No.] = EARLIER ( 'Table01'[Week No.] )
),
'Table01'[PT]
)
AllanBerces , could you share current calculation for column "SUM PT", how did you get 480 for week 46?
If you need to calculate sum of PT per week as calculated column, then you could use this logic:
Total PT per Week =
CALCULATE(
SUM(Table[PT]),
ALLEXCEPT(Table, Table[Week])
)
If you need to add also by year, then beside Table[Week] you would add Table[Year].
Cheers,
Nemanja