Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Rudie
New Member

Get average on total (sum)

My first question... and first time to Power BI and DAX (experience Excel user).

I have 5 data sources that gives me monthly usage, for years. So 12 data points per year for each source.
Now I liked to see the average total usage each month, allong with the average usage for each data source.

The output should be something like, 
with 3 data sources:
Month | S1 | S2 | S3 | Total
Jan | 0,1 | 0,4 | 1,1 |  1,6

Feb | 0,2 | 0,3 | 1,0 | 1,5

etc..
(Where S1/Jan 0,1 is the average usage for January for all years.)

How? I feel I dont know were to start..

1 REPLY 1
Anonymous
Not applicable

Hi @Rudie,

 

Please share some sample data for test and coding formula.

 

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors