Non-numerical averages

[hannahemeredith]

Hello,

I'm very new to Power Bi, so I apologize in advance for asking such an easy question. I'm trying to display the average gate wait time for passengers at an airport. Responses came directly from a survey. Gates are listed as A1, A2, A3... and gate wait time is listed as "Less than 15 min", "16 to 30 mins", "31 to 59 mins", .... "More than 2 hrs". I'm trying to display the average gate wait time per gate. I'm sure it's easy to do but it is proving difficult as the responses are non numeric. How would I do this?

Thanks!

[v-piga-msft]

Hi @hannahemeredith，

Have you solved the problem with the method @Greg_Deckler mentioned?

If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, could you share a dummy pbix file which can reproduce the scenario and your expected output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry

[Greg_Deckler · Accepted solution]

So, you need to use a SWITCH statement in a calculated column to convert the text responses to some numeric value.