Power Query - Offset a date, datetime or time column

Customers will be able to shift a date, datetime or time column backwards or forwards in time with a new Offset transformation, choosing the direction and the amount without writing custom logic.Shifting a date column is one of the most common preparation steps customers perform, and one of the fussiest to do by hand. Customers offset dates to compare a period against the same period a year earlier, to align a transaction date with the fiscal calendar their business reports on, to correct for a source system that records timestamps in a different time zone, or to account for a known lag between when an event happened and when it was captured. Each of these previously meant a custom column and M that had to handle month lengths and type conversions correctly. The Offset transformation applies the shift directly to the column, keeping its type intact and the resulting query readable to whoever maintains it next.