title: Sorting in a specfic Order using PowerQuery
body: <p>I have a table with 5 fields with a column containing the following:</p>
  
  <p>Medium 
  High 
  Low</p>
  
  <p>If I sort in ascending order the data sorts in alphabetical order:</p>
  
  <p>High
  Low
  Medium</p>
  
  <p>In the advanced editor how do I change the code in PowerQuery so that it sorts like the below:</p>
  
  <p>High 
  Medium
  Low</p>
  
  <p>My current syntax in the editor is this: </p>
  
  <p>Table.Sort(#"Filtered Rows",{{"Rating", Order.Ascending}})</p>