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
Anonymous
Not applicable

calculate average wait time

I have 3 columns.
1. A column that has all the states
2. A column that has the wait times of patients who needed to see a doctor.
3. A column that has the Doctors who works in a particular network. N stands for in network and Y stands for out of network which I filtered out.

I’m trying to calculate the average wait time by state who's in network. looking for the correct measure to use. I need to display the average wait time in a line chart.

 

 

 

Column1Column3Column4
   
VT0:00:34N
   
VT0:00:59N
   
VT0:00:45N
   
VT0:00:37N
   
VT0:00:21N
   
VT0:00:17N
   
VT0:00:20N
   
VT0:01:09N
   
VT0:00:24N
   
VT0:05:57N
   
VT0:00:44N
   
VT0:01:55N
   
VT0:01:30N
   
VT0:02:00N
   
VT0:01:47N
   
VT0:00:28N
   
VT0:00:22N
   
VT0:00:47N
   
VT0:00:43N
   
VT0:02:31N
   
VT0:00:23N
   
VT0:00:10N
   
VT0:06:09N
   
VT0:02:02N
   
VT0:04:09N
   
VT0:01:36N
   
VT0:01:13N
   
VT0:03:27N
   
VT0:04:01N
   
VT0:02:36N
   
VT0:02:55N
   
VT0:07:21N
   
VT0:12:05N
   
VT0:06:59N
   
VT0:05:43N
   
VT0:01:03N
   
VT0:06:20N
   
VT0:04:30N
   
VT0:03:03N
   
VT0:06:19N
   
VT0:04:39N
   
VT0:03:46N
   
VT0:04:32N
   
VT0:02:10N
   
VT0:05:33N
   
VT0:02:58N
   
VT0:02:45N
   
VT0:17:54N
   
VT0:07:30N
   
VT0:04:12N
   
VT0:00:11N
   
VT0:07:50N
   
VT0:08:25N
   
VT0:16:33N
   
VT0:04:22N
   
VT0:06:34N
   
VT0:02:06N
   
VT0:06:15N
   
VT0:03:58N
   
VT0:01:25N
   
VT0:02:01N
   
VT0:00:41N
3 REPLIES 3
Greg_Deckler
Super User
Super User

@Anonymous Try these:

Duration to Seconds Converter - Microsoft Power BI Community

Chelsie Eiden's Duration - Microsoft Power BI Community


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

that didnt work out for me @Greg_Deckler 

Okay I will try those. I was under the assumption and average function would be used to calculate avg wait time 

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 Solution Authors