How to create a calculated column based on two other columns

Question

&nbsp;Hello,&nbsp;I have a database that has a customer's request number (ex: 98329 - wardrobe) and one more column with hierarchy codes (1- Send raw material 2- Product Manufacturing 3- Send to customer 4- Assembly of product). I want to make a column only with the smallest number that appears in the hierarchy, for example:&nbsp;Request number&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Code&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; First Code&nbsp;Nº 9485 -Wardrobe&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp;&nbsp;Nº 9485 -Wardrobe&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;Nº 9485 -Wardrobe&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2&nbsp;-----------------------Nº 9481 - TV Panel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;&nbsp;Nº 9481 - TV Panel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;Nº 9481 -TV Panel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Any ideias how to create that column?

greg_deckler · Accepted Answer

julia-wzl85d&nbsp;Sure:
First Code Column = 
  VAR __RequestNumber = [Request number]
RETURN
  MINX(FILTER('Table',[Request number] = __RequestNumber),[Code])

Forum Discussion

How to create a calculated column based on two other columns

Hello,

2 Replies

Related content

TMDL - calculated column

Semantic model - create calculated column

Create columns group

Direct Lake Model - Calculated Column/Tables

Create calculated Rank column in Powerbi