Forum Discussion

Pal03's avatar
Pal03
Frequent Visitor
8 years ago
Solved

Sum over partition by

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.   ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

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

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

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

Pal03's avatar
Pal03
Frequent Visitor
8 years ago

Thanks a ton . It works !!

  • Pal03's avatar
    Pal03
    Frequent Visitor
    8 years ago

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