How to add the running total column

[naoyixue1]

Hey there,

Do you know how to add a column to highlight the running total by date and by SKU ? Thanks!

[naoyixue1 · Accepted solution]

I think I figured it out. The formula should be as below..

[lucadelicio]

I hope I have been helpful.
Mark it as a solution if resolve your problem.

Ciao!

[naoyixue1]

Any thoughts? I'm thinking I should apply sumx with earlier function by SKU and by Date...any thoughts? Thanks!

[lucadelicio]

Is this what you want?

Measure =

CALCULATE(

    SUM(Tabella1[DEMANDS])

    ,DATESYTD(Tabella1[DATE])

)
I miss a comma on the formula.

I hope I have been helpful.
Mark it as a solution if resolve your problem.

Ciao!

[naoyixue1]

Sorry, it doesn't work. But thank you though.

[lucadelicio]

Try:
Measure =
CALCULATE(
SUM('Table'[Demands])
DATESYTD('Datatable'[Date])
)

I hope I have been helpful.
It's more easier to help you if you upload your pbix.
Mark it as a solution if resolve your problem.

Ciao!

[naoyixue1]

Thanks for your help. But it doesn't work.  

[lucadelicio]

It doesn't work because you don't ask if it is a measure or a calculated column. I give you a measure and you use it like a calculated column.

[naoyixue1]

Oh, gotcha. thanks!

[lucadelicio]

Mark it as a solution if resolve your problem.

Ciao!