Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
12 | |
9 | |
9 | |
9 |
User | Count |
---|---|
21 | |
14 | |
14 | |
13 | |
13 |