Forum Discussion
Calculating Total Employees each Month
Hi All, Looking to create a measure which tells me which employees are present at a certain month and year. I have a "Persons" Table with the following fields: Full Name, First Name, Last Na...
I'm getting this error now appearing with this updated one.
"the expression refers to multiple columns. Multiple columns cannot be converted to scalar value."
johnt75
Super User
Super Usercan you post a shot of the full measure so we can see where the red lines are and see what exactly it is complaining about
Please see attached full shot of the measure.
I basically would like to get the figures below. So during December 2022 I had 179 Employees with a start date equal or less than 31/12/2022, and a leaving date equal or less than 31/12/2022 or blank. Then in Jan 2023 184. Etc etc.