Forum Discussion
DAX for Remaining Month Calculation
If an employee joins in the mid of the financial year we give him an Annual Leave benefit Based on
annual leave = [Month when the employee joined]- [JULY (End of Finacial Year )] * 1.67/Month
heygowtam , Try a new column
Leaves =
var _date= [Join Date]
var _eoy = if(month(_date) <=7, Date(Year(_date),7,31) , Date(Year(_date)+1,7,31) )
return
(datediff(_date, _eoy,Month)+1) *1.67
3 Replies
heygowtam , Try a new column
Leaves =
var _date= [Join Date]
var _eoy = if(month(_date) <=7, Date(Year(_date),7,31) , Date(Year(_date)+1,7,31) )
return
(datediff(_date, _eoy,Month)+1) *1.67
and the question is...? 😉
Hi heygowtam ,
Whether the advice given by amitchandak has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry
