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

The Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more

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 and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.