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)))
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!