[SOLVED] First Day of Last Month in Power Query M

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.


← Back to the Posts

let
    Source = Date.StartOfMonth(Date.From(Date.AddMonths(DateTime.LocalNow(),-1)))	
in
    Source

Similar