Skip to main content
cancel
Showing results for 
Search instead 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

Reply
MontyUK
New Member

Average of Column Totals

Hi,  I have a report that brings together data from a table, and groups data per month by summing numbers.  I need to calculate the average of the column totals (Fiscal Month), NOT the average of each column plotted for that data if that makes sense.

 

The standard AVERAGE just takes the average of each fiscal month, and plots that.  I hope this makes sense.  Any help greatly appreciated.

 

Screenshot 2023-01-19 170558.png

1 REPLY 1
Arul
Super User
Super User

@MontyUK ,

Can you provide one example with the sample data what you have? or else check the below thread whether it is solving your requirement.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Get-the-average-of-a-column-value-based-on-to... 

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.