title: In powerBi how can i separate a column with text, positive and negative decimal numbers to different columns please
body: <p>I have a the below column in PowerBI where Value column has decimal numbers both positive and negative and text. I need all of these to be in different columns.</p>
  <p>How can I do that please.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Values</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>-20.1</td>
  </tr>
  <tr>
  <td>10</td>
  </tr>
  <tr>
  <td>31.2</td>
  </tr>
  <tr>
  <td>on</td>
  </tr>
  <tr>
  <td>off</td>
  </tr>
  <tr>
  <td>disarmed</td>
  </tr>
  <tr>
  <td>armed</td>
  </tr>
  <tr>
  <td>33</td>
  </tr>
  <tr>
  <td>-20</td>
  </tr>
  </tbody>
  </table>
  </div>