Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have column for Date of Hire, Date of termination , and Last performance review date. How do I get length of service from these data?
Hi,
This is done with the DATEDIFF function. You can use this function by making a new column and then follow the instructions here:
https://learn.microsoft.com/en-us/dax/datediff-function-dax
Essentially it takes 2 dates and works out the difference between them. You can specify what unit of measurement you want this difference to be in e.g. Years, Days etc.
Please accept as solution if this helped.
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |