Day 1 + Day 2 + Day 3

[Jimmy Ledbetter]

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[TABLE="width: 500"]
<tbody>[TR]
[TD]1/1
[/TD]
[TD]8000
[/TD]
[/TR]
[TR]
[TD]1/2
[/TD]
[TD]9000
[/TD]
[/TR]
[TR]
[TD]1/3
[/TD]
[TD]10000
[/TD]
[/TR]
[TR]
[TD]1/4
[/TD]
[TD]11000
[/TD]
[/TR]
[TR]
[TD]1/5
[/TD]
[TD]12000
[/TD]
[/TR]
</tbody>[/TABLE]

Here is what I would like to achieve[TABLE="width: 500"]
<tbody>[TR]
[TD]1/1
[/TD]
[TD]8000
[/TD]
[TD]8000
[/TD]
[/TR]
[TR]
[TD]1/2
[/TD]
[TD]9000
[/TD]
[TD]17000
[/TD]
[/TR]
[TR]
[TD]1/3
[/TD]
[TD]10000
[/TD]
[TD]27000
[/TD]
[/TR]
[TR]
[TD]1/4
[/TD]
[TD]11000
[/TD]
[TD]38000
[/TD]
[/TR]
[TR]
[TD]1/5
[/TD]
[TD]12000
[/TD]
[TD]50000
[/TD]
[/TR]
</tbody>[/TABLE]

Does anyone know how I can do this?

 

[scottsen]

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.

 

[Jimmy Ledbetter]

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

 

[scottsen]

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.

 

[thomdeluca]

I had a similar question, how to create a cumulative measure (to create a running total).

The answer I received directed me to view: Cumulative Total – Dax Patterns