Forum Discussion

julia-wzl85d's avatar
julia-wzl85d
New Member
5 years ago
Solved

How to create a calculated column based on two other columns

  Hello,  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...
Need Help
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    julia-wzl85d Sure:

    First Code Column = 
  VAR __RequestNumber = [Request number]
RETURN
  MINX(FILTER('Table',[Request number] = __RequestNumber),[Code])