I’m looking for some assistance with writing a DAX measure.
I have 2 Tables (Dates & Activity)
Current the Activity table has to 2 x Date fields (Work Recvd & Work Complted) with the dates table connected to Work Recvd.
I am trying to establish what the Buffer level of activity is with following concepts:
Net Flow = Inflow- Outflow
Buffer =Net Flow + previous day’s buffer (+ or minus)
I’m not sure how i can write the DAX formula. when i use the date add function i get incorrect results. Any assistance or please point me in the direction of any previous posts/tutorials with similar concepts.
I have a screenshot to attach but for some unknown reason it will not upload the screenshot.