Hi All,
Requesting one question based on week ending date. The formula below is perfect when we want to aggregate the values for every Friday and the days before it. Thanks to @Anand Meenakshi Sundaram
Opened on (by week) -
DATE(DATEADD('day', IIF(DATEPART('weekday', [Opened On])=7,6,6 - DATEPART('weekday',[Opened On])), [Opened On])).
The sheet 1 and aggregate every Friday in the attached workbook are based out of the above formula.
I would like to aggregate the values for every Monday and the days before it till last Monday. For example - I would like to have the data aggregated from 5th May'20 till 11th May'20 for 11th May'20.
Attaching the workbook.
Regards,
Rishi Saka
Rishi,
Use this formula
DATE(DATETRUNC('week',[Opened On]+6, 'monday'))
Hope this helps. If it does please mark helpful and correct to close.
Thanks,
Anand
