Forum Discussion
creating a measure with multiple filters
Hi All, Need help with a measure, I need to get an accurate headcount of employees for the last two months on a rolling basis. I have created a headcount measure, but i have to put filters on the ...
Anonymous
Are you putting comma correctly?
Var Startdate = DATE(Year(enddate), Month(enddate)-2, DAY(enddate)+1)
Getting this error
The syntax for 'DAY' is incorrect. (DAX(Var enddate = Max(vwBambooEmployeeHeadCount[AS_OF_DATE])Var Startdate = DATE(Year(enddate), Month(enddate)-2 DAY(enddate)+1)retu
1Count =
Var enddate = Max(vwBambooEmployeeHeadCount[AS_OF_DATE])
Var Startdate = DATE(Year(enddate), Month(enddate)-2 DAY(enddate)+1)
return
CALCULATE(COUNT(vwBambooEmployeeHeadCount[Accurate Head Count]), 'vwBambooEmployeeHeadCount'[STATUS] = "ACTIVE", DATESBETWEEN('vwBambooEmployeeHeadCount'[AS_OF_DATE], startdate, enddate))
Kumail
Impactful Individual
Impactful IndividualAnonymous
Are you putting comma correctly?
Var Startdate = DATE(Year(enddate), Month(enddate)-2, DAY(enddate)+1)