DAX running (cumulative) value over time

[thhmez7]

Hi,

I tried the following DAX formula to calculate the cumulative quantity, but the values to remain the same in "Quantity Running". In 2nd row it should be 135 (125 + 10).

There is a relationship between Date[Date] and Salesorderdetail[requestdeliveryby].

Thanks.

[Ashish_Mathur]

Hi,

Assuming the Date column in the visual has been dragged from the Date Table, write these measures:

Quantity sold = sum(salesorderdetail[Quantity])

Quantity sold YTD = calculate([Quantity sold],datesytd(calendar[date),"31/12")

Hope this helps.

[Anonymous · Accepted solution]

@thhmez7 

Your dax should correct if you are creating a measure. If you want a calculated column, it should be:

Columns = calculate(sum[quantity]),filter(date, [date]<=earlier[date]))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Try this 

Quntity Running : =

VAR MaxDate = MAX ( 'Date'[Date] ) -- Saves the last visible date
RETURN
CALCULATE (
[Quantity], -- Computes sales amount
'Date'[Date] <= MaxDate, -- Where date is before the last visible date
ALL ( Date ) -- Removes any other filters from Date
)

[thhmez7]

Still same result:

[Anonymous]

I think you doing something wrong- check again 

[Anonymous]

send me your file if possible