Forum Discussion

heygowtam's avatar
heygowtam
Helper II
3 years ago
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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

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