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

[Javi_Pérez_C]

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!

[v-sihou-msft · Accepted solution]

@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. 

Regards,

[Anonymous]

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

[DavidVK]

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

Thanks!

[Tuvdata]

Thank you

[igorabdo]

Thanksss!!!

I saved me into another problem

[Shafi293]

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

[JordanSloan5]

I am have the same problem. Any response?

[lisaolu]

Did you get a solution to this by any chance

[Greg_Deckler]

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