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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Javi_Pérez_C
New Member

Add a number of days to a date in a new column

Hi all,

 

How I can calculate in a new column an Estimated Time of Arrival (ETA) addinga number of days from other column with a date. I saw that one solution is to create a new table with the number of days to add, but I'm not understanding how to create the relationship.

 

I appreciate your support!

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

@Javi_Pérez_C

 

DATEADD() function requires the result date exists in the same column. I suggest you directly add days on date. It can be done via either DAX or Power Query approach. 

 

11.PNG

 

22.PNG

 

Regards,

View solution in original post

9 REPLIES 9
v-sihou-msft
Employee
Employee

@Javi_Pérez_C

 

DATEADD() function requires the result date exists in the same column. I suggest you directly add days on date. It can be done via either DAX or Power Query approach. 

 

11.PNG

 

22.PNG

 

Regards,

Anonymous
Not applicable

Hi! I have this kind og scenario but I need to exclude weekends in the calculation.

This solved my problem with the mismatch of days between SharePoint list and PowerBI query.

 

Thanks!

Thank you

Thanksss!!!

I saved me into another problem

Facing same issue but im having noOfDays column in another table then how should i add it to a date in different table ,Here ur using 1 which is constant what if i wanna take this days dynamically from another table???? Plz helpp Thanx in advance

I am have the same problem. Any response?

Did you get a solution to this by any chance

 

Greg_Deckler
Super User
Super User

Tough to help without more information, but I think you are looking for DATEADD:

https://msdn.microsoft.com/en-us/library/ee634905.aspx

 

Please see:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.