Calculating Sum by Date

[meghansh]

Hi friends,

I have this problem:

Date	Category	Value
1 Apr 2023	Refund	10
1 Apr 2023	Sales	15
2 Apr 2023	Requests	5
2 Apr 2023	Refund	22
2 Apr 2023	Sales	3
3 Apr 2023	Requests	2
3 Apr 2023	Refund	1
3 Apr 2023	Sales	20

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

Date	Category	Value	Sum
1 Apr 2023	Refund	10	25
1 Apr 2023	Sales	15	25
2 Apr 2023	Requests	5	30
2 Apr 2023	Refund	22	30
2 Apr 2023	Sales	3	30
3 Apr 2023	Requests	2	23
3 Apr 2023	Refund	1	23
3 Apr 2023	Sales	20	23

Thanks.

[DOLEARY85 · Accepted solution]

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 👍