title: How do you create a new column based on Max value of 1 column and Category of another?
body: <p>I am working with a bunch of data for my job creating status reports on the documents that we are working through that we then assign to an area. We decided to use PowerBI as an interactive way to see where everything is at.</p>
  <p>Using Power BI Desktop I've created a new table that excludes documents that are not ready for QC but we have several different statuses. Instead of creating a new table for each status type (since some can be grouped together) I would like to create a new column that has the grouped status value's Max for each area. The higher the Status Value the further it is from being complete.</p>
  <p>EX:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Record:</th>
  <th>Area:</th>
  <th>Status Value:</th>
  <th>Max Status Value:</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>152385</td>
  <td>A</td>
  <td>1</td>
  <td>2</td>
  </tr>
  <tr>
  <td>354354</td>
  <td>B</td>
  <td>2</td>
  <td>3</td>
  </tr>
  <tr>
  <td>131322</td>
  <td>B</td>
  <td>3</td>
  <td>3</td>
  </tr>
  <tr>
  <td>132136</td>
  <td>A</td>
  <td>2</td>
  <td>2</td>
  </tr>
  <tr>
  <td>213513</td>
  <td>A</td>
  <td>1</td>
  <td>2</td>
  </tr>
  <tr>
  <td>351315</td>
  <td>B</td>
  <td>2</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>If anyone knows how to get the Max Status Value column that would greatly help. I did find another post (<a href="https://community.powerbi.com/t5/Desktop/LOOKUPVALUE-return-min-max-of-values-found/td-p/657534" rel="nofollow noreferrer">https://community.powerbi.com/t5/Desktop/LOOKUPVALUE-return-min-max-of-values-found/td-p/657534</a>) that was similar but I'm still new to DAX and could not figure out how to apply it to my situation.</p>