cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

DATEADD Function Not Working

Hi,

 

I am having all sorts of troubles for something that should be easy.

 

I have a date column, and i simply want to add the number of months shown in another column to the original date.

 

The Date is in a table called X_Services, the Additional months i want to add is from a related table called "Promo_Months".

 

In the table X_Services i have the promo_months value show via the related function. Not sure if this is what's causing the issue.

 

I am using the DATEADD function to no avail, can anyone shed some light on how to successfully achieve this.

 

I did this and got the result on one occassion, but mysteriously only where the additional months value of 2 was shown .. the rest didn't show?

Date.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: DATEADD Function Not Working

@ToddMate  hi can you share some data (not in pic format, text format) from both tables

 

and also provide the calculations you are using.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: DATEADD Function Not Working

@ToddMate  hi can you share some data (not in pic format, text format) from both tables

 

and also provide the calculations you are using.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Helper II
Helper II

Re: DATEADD Function Not Working

Hi @vanessafvg 

 

I've sorted it out, thanks for your offer of assistance though.

Highlighted
Super User II
Super User II

Re: DATEADD Function Not Working

@ToddMate  great what was the issue?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors