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.
Hi everybody,
I have a start date, end date and salary column for employees and I want to calculate phased salary. For instance, A earn 48000 per year. The start date is April 8 and the end date is July 1. The phased salary equals to 48000/12*2.25. Any advice will be greatly appreciated. Thanks!
Solved! Go to Solution.
Try using DATEDIFF to add a calculated column.
Try using DATEDIFF to add a calculated column.
Why 2.25? Explain.
Hi,
If someone starts on April 8, he works for 23 days in that month and thereafter for the 2 complete months. How does that become 2.25?
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |