DAX for Remaining Month Calculation

[heygowtam]

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 

[v-henryk-mstf]

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

[amitchandak · Accepted solution]

@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

[lukiz84]

and the question is...? 😉