Forum Discussion
Solved
Average for the month
Hi. I need a monthly average of the following fornightly data. Note: Some months have two fortnights and some have three. I will be filtering by month and year. Happy to use M Query or DAX, which...
Thanks Jihwan_Kim and Anonymous
I also got to it with the CALCULATE function. I had
=CALCULATE(AVGERAGE(tblPayroll[Actual payroll FTEs per fnight]),
FILTER(tblPayroll,tblPayroll[Date] )
)which seems to work.
I will also try to figure the logic suggested by Anonymous
Hello Mikeincairns ,
Add a new column month
Month = MONTH([Date])
Then the average of each month is
New measure = CALCULATE(AVERAGE([Actual Payroll FTEs per fnight]),ALLEXCEPT(table,[Month]))