Forum Discussion

jamc's avatar
jamc
Frequent Visitor
3 years ago

RUNNING TOTAL FUTURE HORIZON

Hi im actually scraching my head into this I want to know if there is a Dax formula that can help out where I can get Future Excess amount taking account any Date of this table (Starting the Excess ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

jamc , You need use this formula after week 5, not sure on week 5 logic , using date tbale joined to date of your table 

 

CALCULATE(firstnonblankvalue('Date'[Month]),sum(Table[Dmd Total]),all('Date')) +  - CALCULATE(SUM(Table[Initial ]),filter(date,date[date] <=maxx(date,date[date])))

jamc's avatar
jamc
Frequent Visitor
3 years ago

Hi thanks ti does calculate me but it does not get the value that I want, I probably however im goint to try to joint the Date table into the mix