Today is the 29th of July 2021... this Power Query M returns 1st of June 2021 like `1/06/2021`
me@jaykilleen.com wrote this about 3 years ago and it was last updated about 3 years ago.
let
Source = Date.StartOfMonth(Date.From(Date.AddMonths(DateTime.LocalNow(),-1)))
in
Source