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 amount for WK 5 as ane example in Column H6), and a running calculation where I cant Deduct from that total the exces amount, (ill attach the excersisce with the desireble outcome column  I) 

 

Any help will be appreciate it

2 Replies

  • 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