Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a calendar table in Power Query with the end date dynamically calculated using the following step:
= Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow()))
But i want to change this expression to be always 3 months from today, so that means it should also go forward to the next year, for example, if today is 10 December 2022, then it should go forward 3 months into March 2023.
Is that possible? Any help is much appreciated.
Solved! Go to Solution.
Hi @Anonymous
Date.AddMonths(DateTime.Date(DateTime.FixedLocalNow()),3)
Hi @Anonymous
Date.AddMonths(DateTime.Date(DateTime.FixedLocalNow()),3)