Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Rolling 4 Week Cash Flow

Hello, I am trying to generate a rolling 4 week cash flow. I am unable to send a file because of the private nature of the data so I will try to be succinct as possible.   My Weekly Cash Flow measu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

I might be looking at this the wrong way but, would this work?:

CALCULATE (
    SUM ( [Weekly Cash Flow]),
    DATESINPERIOD ('Date'[Date], MIN ( 'Date'[Date] ), -28, DAY )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you for your reply. Regrettably the same value is created with this method.