Forum Discussion

hannahemeredith's avatar
hannahemeredith
Regular Visitor
8 years ago
Solved

Non-numerical averages

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!

  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

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

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    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