DAX Expert

We are looking for a DAX which can do the DAX calculation shown in excel.

Please note: it needs to have a lag from one day to 3 days to 14 days as shown