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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
kteare
Frequent Visitor

Calculations Using a Monthly Average

I am working with data where the # of data points in each month varies, for this reason when we try to sum up and average the Operational Uptime over a full year the calcuations weight the data differently and give us a number that isn't the correct calculation.  Essential what I want to to is get the Operational Uptime % by month and then use that number to trend by month and average out over any given time period (ie 2017)

 

The calculations Im using are as follows:

Operational Uptime % = CALCULATE('ARU Data'[Runtime %]+'ARU Data'[No Demand %])

 

Runtime % = CALCULATE(DIVIDE('ARU Data'[Calendar Hours]-'ARU Data'[Asset Availability]-'ARU Data'[Asset Reliability]-'ARU Data'[Asset Utilization],'ARU Data'[Calendar Hours],0) )

No Demand % = CALCULATE(DIVIDE('ARU Data'[Alternate or Intermittent Downtime],'ARU Data'[Calendar Hours],0))+0

 

How would I convert these calculations to show a value per month?

Thanks

 

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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