Timeshifting data to remove lag

[Davis Tolman 2]

I'm looking at the John Hopkins Covid-19 dataset and have noted that the peaks and troughs in Covid Confirmed Cases preceeds the peaks and troughs of Covid Deaths by around 18 to 21 days. Is there a way to time-shift the Covid Donfirmed Case data by -21 days in order to do a more rigours analysis of this relationship

[Fabian Duerr]

You could add a calculated columnthat contains the date column value shifted by 21 days. Please use the DateAdd() function for this:

DateAdd('day', -21, [Date Column])If confirmed cases and covid deaths are sharing this column, you can additionally work with a case statement.