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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
rober136
Frequent Visitor

Find Average from month totals over a specific period of time

Hello,

 

At my org we have a score that we call "Uptime Efficiency Score". The score is totaled at the end of each month and then divided by how many months into the fiscal year we are.

 

In my dataset, I have the field AA_UptimeEfficiency that correctly sums correctly, but when I try to use average, it comes out correctly. I think the problem is that it is grabbing all of the zero and blank values and dividing it by all of that. I would like to either have it ignore those values and only find the average of months total instead.

 

Example below. If we want to find January's uptime efficiency score we would take the total (760) and divide it by 4 (4 months into our fiscal year). But instead 190 (760\4) it comes out as 27.14, which is incorrect. To add on top of that, I would need it to update for each month automatically if possible. I'm going to be honest here and say I have no idea where to start with this. My only other method would be to manually update it which I can do, its just a pain.

 

rober136_0-1708729049329.png

 

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

So for each month of the FY, you want to divide the total by the number of months from the start of the FY till that specific month.  Am i correct?  If yes, then share the download link of the PBI file.  Also, when does the FY start?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Yes, I believe you are correct. Unfortunately my organization does not have a way for me to share this data externally via a link. Is it possible for me to add an attachment somewhere? I don't see an option.

There is no way to attach a file here.  You have to share a download link.  When does th e FY start?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

FY starts in October. So it'd be something like uptimeefficiency\createddate month (FY)?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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