Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago
Solved

Sumx- Per Week

Hi good day, Pls need assistance on how can i get the sum per week base from Phase and Trade. Thank you  
Need Help
mickey64's avatar
mickey64
Super User
2 years ago

For your reference.

 

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago

Hi mickey64 Thank you for the reply, but i need it as Calculated Column.

 

 

  • mickey64's avatar
    mickey64
    Super User
    2 years ago

    For your reference.

    Sum_Count = CALCULATE(SUM(DATA[Count]),ALLEXCEPT('DATA','DATA'[Week No.],'DATA'[Phase],'DATA'[Trade]))

     

    Sum_Outcome = CALCULATE(SUM(DATA[Outcome]),ALLEXCEPT('DATA','DATA'[Week No.],'DATA'[Phase],'DATA'[Trade]))