Date comparision in Measure

[nehapathak]

I want to count the employees who have joined before 15/5/2017

what expression should be used for measure.

[ahaahaaha]

Hi,

Try

Count({<YourFieldDate={"<=$(=Date('15/5/2017'))"}>}employees )

[sunny_talwar]

May be like this

Count(DISTINT {<DateField = {"$(='<=' & Date(MakeDate(2017, 5, 15), 'D/M/YYYY'))"}>} EmpID)

[Anonymous]

Something like

count(distinct if(JoinedDate<'15/5/2017', Employee))

[Ivan_Bozov]

Hello! You could use something like:

Count({<YourDateField={'<15/5/2017'}>}Distinct YourEmployeesField)

P.S. Seems like a lot of people were faster than me