Sum over partition by

[Pal03]

Hello everyone , I am trying to achieve this . I have a table with Date , account , segment , revenue and sector. I am trying to get 

total revenue based on Date , Account , segment only.

My total revenue changes  everytime there is a new date ,account , segment combination  (ignoring the sector) Please help

[Anonymous]

Can we do the same in Power query?

[Phil_Seamark · Accepted solution]

Hi @Pal03

Here is how you can do it with a calculated column

Total Revenue = 
    CALCULATE(
        SUM('Table1'[Revenue]),
        FILTER(
            'Table1',
            'Table1'[Date] = EARLIER('Table1'[Date]) &&
            'Table1'[Account] = EARLIER('Table1'[Account]) &&
            'Table1'[Segment] = EARLIER('Table1'[Segment]) 
            )   
)

[iluvcoding_91]

A couple of years let, but thanks for this reply!! it saved my @$$

[Anonymous]

Thanks a lot!!

[mleepin]

Just wondering - Would it be possible to do this using power query / M?

[Pal03]

Thanks a ton . It works !!

[Pal03]

Actually quite excited that it works in power BI. Once again thank you 🙂