Calculate expected end date based on start date and number of days

[Anonymous]

I have a start date column and a number of days column, want to find expected end date. 

Start Date	Number of Days	Expected End Date
1/1/2020	62

[negi007]

@Anonymous  create a calculated column using below dax syntex in your data table 

Expected_End_Date = DATEVALUE(Date_Data[Start_Date].[Date]+Date_Data[Number_Of_Days])

[amitchandak]

@Anonymous , create a new column

expected end date =[Start Date]+ [Number of Days Expected End Date]

[Anonymous]

I'm getting the following error? 

[negi007]

@AnonymousYou need to add the new column in powerbi desktop view not in power query window. There you can add new column which can take + operator to arrive at expected end date. 

[az38]

Hi @Anonymous 

try column

Expected End Date = [Start Date] + [Number of Days]

[Anonymous]

FYI: I got this error message: 

Expression.Error: We cannot apply operator + to types Date and Number.
Details:
Operator=+
Left=7/30/2019
Right=203

[Anonymous · Accepted solution]

Hi @Anonymous ,

Try use Date.AddDays() function.

https://docs.microsoft.com/en-us/powerquery-m/date-adddays 

Result:

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.