Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I am using this to get today's data:
let
Source = Date.ToText(Date.From(DateTime.LocalNow()), "dd.MM.yyyy")
in
Source
It is working well, but I also need tomorrow's data. I must use this format due to the date settings at the data source. However I am interested in getting tomorrow's data. How should i change it? I already tried this, but it doesn't work since I need to use dd.MM.YYYY format.
Today = DateTime.Date(DateTime.LocalNow()),
Tomorrow = Date.AddDays(Today, +1),
Thanks in advance.
Solved! Go to Solution.
Hi @IF
Just re-apply the same format, see here
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
I hope this is helpful
Hi @IF
Just re-apply the same format, see here
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
I hope this is helpful