Help With DAX function for calculating Average

[Anonymous]

Hi All,
I have a PowerPivot table (below) and I am trying to figure out how to get the [Average Workload For The Month] (last column below).
Any help is greatly appreciated

[Year] [Month] [MonthName] [Week] [WORKLOAD] [Average Workload For The Month]
2020 1 Jan 1 1,772 5,866
2020 1 Jan 2 5,751 5,866
2020 1 Jan 3 6,856 5,866
2020 1 Jan 4 7,061 5,866
2020 1 Jan 5 7,889 5,866
2020 2 Feb 2 6,600 6,288
2020 2 Feb 3 6,195 6,288
2020 2 Feb 4 5,813 6,288
2020 2 Feb 5 6,544 6,288

[amitchandak]

@bconner, Treating as a

calculate(average(table[WORKLOAD]), allexcept(Table,Table[Month]))

[AlB · Accepted solution]

Hi @Anonymous 

You can create a calculated column:

Average Workload For The Month =
CALCULATE (
    AVERAGE ( Table1[Workload] ),
    ALLEXCEPT ( Table1, Table1[Year], Table1[Month] )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

 Cheers 

[amitchandak]

@Anonymous , Try like

calculate(average(table[WORKLOAD]), allexcept(Table,Table[Month]))