Day 1 + Day 2 + Day 3

Jimmy Ledbetter

New Member
Joined
May 30, 2014
Messages
2
Good Morning all, I am very stuck on a problem and hope to get some help. I want to create a DAX measure that aggregates each total by day. Example
1/1
8000
1/2
9000
1/3
10000
1/4
11000
1/5
12000

<tbody>
</tbody>

Here is what I would like to achieve
1/1
8000
8000
1/2
9000
17000
1/3
10000
27000
1/4
11000
38000
1/5
12000
50000

<tbody>
</tbody>

Does anyone know how I can do this?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
If you are using a traditional calendar (not like a 4,4,5 or else custom to your business), then you can just do:

=CALCULATE([MyAwesomeMeasureThatSumsValues], DATESYTD(Calendar[DateKey]))

Or, there is also TotalYTD() you can look up.

You will still need a separate Calendar table, but that's highly recommended regardless.
 
Upvote 0
I thought about that, but I need to calculate from the 1st transaction to current in order to come up with my balance. So if I do a totalytd I lose everything befor jan 1.

J
 
Upvote 0
Ah, your Jan 1 threw me. :)

How about something like...
=CALCULATE([TotalAmt], FILTER(ALL(MyTable), MyTable[Day] <= MIN(MyTable[Day])))

You will have to do something clever if you need a grand total row, but otherwise, should work.
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top