To Find A reliving Date

[venkatvkrp]

Hello, 

i am having a dataset with one column as hire date  and other column as no of days worked.

By using these two i nee the last working day of the employee.

when i am using the below formula 

DATE('EMP'[HireDate].[Year],'EMP'[HireDate].[MonthNo],'EMP'[HireDate].[Day]+'EMP'[TenureDays]), Entire column is giving only one answer. 

[venkatvkrp]

GOt it!, THank you verymuch for the reply

[PC2790 · Accepted solution]

Hello @venkatvkrp ,

You can do it in Power Query by adding a custome column:

Add Column-->CustomColumn and use the Date.AddDays as shown below: