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.
1 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:
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:
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
