Power query subtracting date

[Stanman]

Hi,

Could some one advise how I can add a column that will work out the difference from a date column minus the last month.

As an example running the query on the 1st of June, I would like it to work out 01/01/2020 minus 31/05/2022 or if run July 01/01/2022 minus 30/06/2022

Thank you

 

[GraH]

That's a duration in Power Query.

Duration functions - PowerQuery M

Learn more about: Duration functions

docs.microsoft.com