Forum Discussion

jamc's avatar
jamc
Frequent Visitor
3 years ago

DYNAMIC FUTURE RUNNING TOTAL

Hi    I have really scratiching my head, i have being trying to get a dynamic running total calculation Dax, in which depedning of the week I choose I get a different running total calculation, lik...
Need Info
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

jamc , Try measure like 

 

Cumm Sales =

Var _max = maxx(allselected('Date') , 'Date'[date] )

return

CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date]) && Date[Date] > _max ))

 

 

Cumm Sales =

Var _max = maxx(allselected('Date') , 'Date'[date] )

return

CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date]) && Date[Date] > _max ))

 

But if you need a trend then slicer need to me an independent date table

 

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
return

CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date]) && Date[Date] > _max ))

 

jamc's avatar
jamc
Frequent Visitor
3 years ago

Hi 

 

Ill already try the soluti the first step without success, also we are no cumulating the Dmd it is more  Inventory initial - Dmd Total and that will give you a future inventory amount, afterwards for the next wee will be this new inventory - Dmd for next week and so on (as explained in the formula section in the picture),