Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I am using the following and it is working well. How can I get dynamically: "today-3 years" and "today + end of next year".
For example today is 2024-Oct-29.
today-4 years is 2020-Oct-29
today + end of next year is 2025-Dec-31
Thanks
let Today = Date.From(DateTime.LocalNow()), TodayFormatted = Date.ToText(Today, "dd.MM.yyyy"), TomorrowFormatted = Date.ToText(Date.AddDays(Today, 1), "dd.MM.yyyy") in TomorrowFormatted
Solved! Go to Solution.
= Date.FromText( Text.From( Date.Year(Date.AddYears( Date.From(DateTime.LocalNow()),1))) & "-12-31")
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
You can add year to specific date by Date.AddYear and also calculate the last date of a year by Date. EndOfYear.
So your dates can be achieved by the below formual.
Today date => Date.from(DateRime.LocalNow())
Date of next three year=> Date.AddYear(Date.from(DateRime.LocalNow()),3)
End of next year => Date.EndOfYear(Date.AddYear(Date.From(DateTime.LocalNow()),1))
Hi @IF ,
Both Omid_Motamedise and SamWiseOwl have provided great solutions. Hope they could help you.
If possible, accept the replies as solutions. This will make it easier for the future people to find the answer quickly.
Best Regards,
Stephen Tao
You can add year to specific date by Date.AddYear and also calculate the last date of a year by Date. EndOfYear.
So your dates can be achieved by the below formual.
Today date => Date.from(DateRime.LocalNow())
Date of next three year=> Date.AddYear(Date.from(DateRime.LocalNow()),3)
End of next year => Date.EndOfYear(Date.AddYear(Date.From(DateTime.LocalNow()),1))
THank you. I was asking three year backwards. Is it supposed to be:
Date of next three year=> Date.AddYear(Date.from(DateRime.LocalNow()),-3)
= Date.FromText( Text.From( Date.Year(Date.AddYears( Date.From(DateTime.LocalNow()),1))) & "-12-31")
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.