Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
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()) ...?
Thank you!
Solved! Go to Solution.
let EndDate = Date.From(DateTime.LocalNow())
let StartDate = #date(Date.Year(EndDate)-1,1,1)
Another way would be to use the Date.StartOfYear and Date.AddYears functions.
StartDate = Date.From(Date.StartOfYear(Date.AddYears(DateTime.LocalNow(), -1)))
let EndDate = Date.From(DateTime.LocalNow())
let StartDate = #date(Date.Year(EndDate)-1,1,1)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.