SUM Weekly

[AllanBerces]

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

[nandic]

@AllanBerces in that case, i suppose there are some additional columns which make each row unique.
Based on provided screenshot, for PT 200 we have 4 same rows.

Formula that i provided in previous reply would do 200 * 4 and return 800.
So we need to find makes rows unique to tell in formula to return only the first or last row, otherwise it will multiply.

Cheers,
Nemanja

[AllanBerces · Accepted solution]

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

[nandic]

@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

[AllanBerces]

Hi @nandic for the 480 is the of below

Thank you