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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Will38
Frequent Visitor

Power Bi averaging daily results to fixed budget

I am very new to Database work and Power BI.  I have been tasked with creating a report that will calculate our daily hours for inservice ambulances and create a chart to compare it to our budgeted hours.  I connected this very large database and built out a formula that looks at every shift start Date/Time and Stop Date/Time.  I used the subtraction tool and then converted duration to a number.  This all works.  When I try to bring this into a chart and use the date Hierarchy to include year,  quarter, month, day the averaging will not work.  It bring it down to shift level.  Is there a way to tally all the shifts in a day to compare it?  Thank you for helping this Rookie.  

This is a small sampling of the data.

Will38_0-1669060944465.png

 

 

3 REPLIES 3
Will38
Frequent Visitor

In our database for me to calculate the number of hours each unit worked I must pull their start and end time for the shift.  I do this for each ambulance in the CAD.  After computing the hours and minutes for each unit placed in the CAD that day, I need to total daily hours.  then average it weekly, monthly, quarterly.  I have success averaging quarterly and monthly but when I try to go down to the day, using the date hierarchy, it goes all the way down to the individual shift average.  

v-binbinyu-msft
Community Support
Community Support

Hi @Will38 ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_ Binbin Yu

Will38
Frequent Visitor

I forgot to mention that this report will go into a live dashboard.

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.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors