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.
Dear Experts, I am trying to calculate employees' Retirement Date based on their Date of Birth. I tried the below measure and it is giving me errors.
My data is like this:
I want to display a table to show the total number of employees nearing retirement when I select a date on my slicer.
I'm stuck and I need a way out of this. Please help, thank you.
What is the data type of your column Birth Date?
The data type is Date
Try this measure:
Retirement Date = DATEADD([Birth date],60,YEAR)
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |