Forum Discussion
Solved
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
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