title: Extract the value after the last occurrence of space in Power BI DAX
body: <p>I have data like this:</p>
  
  <ul>
  <li>lm-sample prod </li>
  <li>lm sample prod </li>
  <li>lm-exit nonprod-shared </li>
  <li>lm- value dev</li>
  </ul>
  
  <p>I want to extract just the last value after the first space from right.  So in this example:</p>
  
  <ul>
  <li>prod</li>
  <li>prod</li>
  <li>nonprod-shared</li>
  <li>dev</li>
  </ul>
  
  <p>I tried:</p>
  
  <pre><code>Env = 
  Var FirstSpace = FIND(" ", 'AWS Reservations'[Account])
  Return RIGHT('AWS Reservations'[Account],FirstSpace - 1)
  </code></pre>
  
  <p>But that is giving me odd results.  Would appreciate some help on solving this.  Thanks.</p>