Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
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  
Need Help
  • AllanBerces's avatar
    AllanBerces
    1 year ago

    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's avatar
nandic
Resident Rockstar
1 year ago

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's avatar
AllanBerces
Post Prodigy
1 year ago

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