Forum Discussion
Solved
To Find A reliving Date
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.
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:
2 Replies
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:
GOt it!, THank you verymuch for the reply
