Forum Discussion
jkhan
Helper III
Helper IIINeed help in DAX
Hi All, I am trying to do sum of number of employees based on Date Filter also need to consider employees Termination Date while doing sum. I have written below dax to do cumulative total but ...
jkhan , do you have both start date and termination date ?
Please refer to my blog on a similar topic if that can help. I think you need join with termination date too
amitchandak
Super User
Super Userjkhan , do you have both start date and termination date ?
Please refer to my blog on a similar topic if that can help. I think you need join with termination date too
jkhanHelper III
Helper IIIHi Mr. Amit,
Thanks for reply. I have two Date field in employee master Table 1) Hire_Date 2) Termination_Date
I need to make sum of number of employees based on Date Filter and also need to substract the employee if there Termination Date fall before the selected date.
Sure I will refer the blog and will udpate accordingly.
Thanks & Regards
Jamsher