topic Re: DAX Measure for average employees in a year in DAX Commands and Tips

DAX Measure for average employees in a year

Bfaws — Wed, 10 Jun 2020 19:17:28 GMT

Hi,

I was hoping someone could help. I have a measure below. Its great for creating a measure that gives average of number employees over the last 12 rolling months. I`m looking for a measure that will give me the average number of employees for within the specific year and not the rolling 12 months. Altering the below or another suggestion would be great.

Thanks, in advance,

Brendan

Re: DAX Measure for average employees in a year

stevedep — Wed, 10 Jun 2020 20:05:02 GMT

Just do an average , not averagex, and slice by year?

Re: DAX Measure for average employees in a year

Bfaws — Thu, 11 Jun 2020 05:36:50 GMT

stevedep

Thanks. How do you suggest doing the average? Adjusting the measure submitted while changing averagex to average? Or create a new measure.

Brendan

Re: DAX Measure for average employees in a year

stevedep — Thu, 11 Jun 2020 05:44:57 GMT

Measure = calculate(average ([total FTE]))

Then show per year in your dashboard