cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OHM Frequent Visitor
Frequent Visitor

How to add a number of days (leadtime) to a date

I need a DAX formula to add a number of days (leadtime) to a date, returning a new date. The added days is piced from a variable, so it is not a fixed number.

The needed function will be like this

"Original Date" + "# of days" returns "New Date" 

1 ACCEPTED SOLUTION

Accepted Solutions
Back2Basics Member
Member

Re: How to add a number of days (leadtime) to a date

Hi OHM

 

I would suggest creating a seperate table with the category in one column and additional days in the other. Provided this category is also in the orignial dataset you can link between your current table and this new table, creating a relationship between the category in each table.

 

Then you should be able to create a new column in your original table along the lines of:

 

Leadtime Deadline = [Original Date] + table2[additional days]

 

 

Having the second table means that if any of the variable additional days change you can simply update that table rather than updating the query/calculation. Best of luck

1 REPLY 1
Back2Basics Member
Member

Re: How to add a number of days (leadtime) to a date

Hi OHM

 

I would suggest creating a seperate table with the category in one column and additional days in the other. Provided this category is also in the orignial dataset you can link between your current table and this new table, creating a relationship between the category in each table.

 

Then you should be able to create a new column in your original table along the lines of:

 

Leadtime Deadline = [Original Date] + table2[additional days]

 

 

Having the second table means that if any of the variable additional days change you can simply update that table rather than updating the query/calculation. Best of luck

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 337 members 3,392 guests
Please welcome our newest community members: