Skip to main content
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

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?




Helpful resources

Europe Fabric Conference

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.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors