Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
IF
Post Prodigy
Post Prodigy

Date Tomorrow M language

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.

 

 

1 ACCEPTED SOLUTION
m_dekorte
Resident Rockstar
Resident Rockstar

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

View solution in original post

1 REPLY 1
m_dekorte
Resident Rockstar
Resident Rockstar

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

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.