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