Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Rolling measure missing values

Hi everyone!   I searched through the forum and couldn't find the answer to my problem, so I hope you could help me.   It's a very simple table that I have so I hope the solution is simple as wel...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You need employee left within three months of joining

 

then it should be like

measure  =

 

calculate(count(Table[Employee]), filter(Table, not(isblank(Table[Temination Date])) && datediff([Hire Date],Table[Temination Date], month) <=3 ) )