Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |