Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

avg wait time

im trying to find the avereage of wait times of people who waited to see a doctor. looking for the correct measure to use. i renamed the colums to wait time,state,in network  
Need Help
v-jialluo-msft's avatar
v-jialluo-msft
Community Support
3 years ago

Hi  Anonymous ,

 

What data does the average time to calculate? Is it [in network] = "Y" data?

You can try:

AVG = AVERAGEX(FILTER(ALL('Table'),'Table'[in network] = "Y"),'Table'[wait time])

If that's not what you need, provide sample data and projected output.

 

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    i would make a new column named average wait time once i calculate the averages of the wait time column if that makes sense.