Forum Discussion

meghansh's avatar
meghansh
Frequent Visitor
3 years ago
Solved

Calculating Sum by Date

Hi friends,

 

I have this problem:

 

DateCategoryValue
1 Apr 2023Refund10
1 Apr 2023Sales15
2 Apr 2023Requests5
2 Apr 2023Refund22
2 Apr 2023Sales3
3 Apr 2023Requests2
3 Apr 2023Refund1
3 Apr 2023Sales20
   

 

I need an additional column giving sum over the date. Example, column "Sum" should have the value,

DateCategoryValueSum
1 Apr 2023Refund1025
1 Apr 2023Sales1525
2 Apr 2023Requests530
2 Apr 2023Refund2230
2 Apr 2023Sales330
3 Apr 2023Requests223
3 Apr 2023Refund123
3 Apr 2023Sales2023

 

Thanks.

Need Help
Tips and Tricks
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    this should work:

     

    Measure = CALCULATE(sum('Table'[Value]),ALLEXCEPT('Table','Table'[Date]))
     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    this should work:

     

    Measure = CALCULATE(sum('Table'[Value]),ALLEXCEPT('Table','Table'[Date]))
     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍