I'm looking for an M Query assist.
I'd like to set my StartDate to January 1st of the previous year, and my EndDate to the current day. So, start date should read 01-01-2020 and EndDate should read (today, so 09-23-2021). How would I cast that in M Query?
let StartDate = ...?
let EndDate = Date.From(DateTime.LocalNow()) ...?
Go to Solution.
let EndDate = Date.From(DateTime.LocalNow())
let StartDate = #date(Date.Year(EndDate)-1,1,1)
View solution in original post
Another way would be to use the Date.StartOfYear and Date.AddYears functions.
StartDate = Date.From(Date.StartOfYear(Date.AddYears(DateTime.LocalNow(), -1)))
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.