The problem is that the Ending Headcount measure is a calculated measure and not a column value. Therefore I keep getting the following error message 1 "Measure 'Monthly Headcount'[12 Month AVG Headcount] : The AVERAGE function
only accepts a column reference as the argument number 1"
I don't really want to put the logic for Ending Headcount into the query above. Is there any way around this?
btw...I did try and do a SUM(Ending Headcount) / CountRows(......) and SUM only accepts a column reference as well....
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.