cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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, whichever is easiest.

1 ACCEPTED SOLUTION
Frequent Visitor

Thanks @Jihwan_Kim and @eliasayy

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 @eliasayy

3 REPLIES 3
Frequent Visitor

Thanks @Jihwan_Kim and @eliasayy

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 @eliasayy

Super User

Hi,

Please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

It is for creating a table visualization.

In case calendar table does not exist, please try creating a additional columns in the same table like below, and then use Month Year CC column as an axis.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

Impactful Individual

Hello @Mikeincairns ,

Month = MONTH([Date])

Then the average of each month is

New measure = CALCULATE(AVERAGE([Actual Payroll FTEs per fnight]),ALLEXCEPT(table,[Month]))

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors