Forum Discussion

bhargavanand's avatar
bhargavanand
Icon for Helper I rankHelper I
2 years ago
Solved

fill column based on other column values

Hi,   I have two columns which Code and Names. I want to add a calculated column which should be assigned a number based on a condition that if Code = A and Name = B then 1, if Code = C and Name ...
Need Help
  • foodd's avatar
    foodd
    2 years ago

     

    CalculatedColumn =
SWITCH(
    TRUE(),
    'Table'[Code] = "A" && 'Table'[Names] = "B", 1,
    'Table'[Code] = "C" && 'Table'[Names] = "D", 2,
    'Table'[Code] = "E" && 'Table'[Names] = "F", 3,
    'Table'[Code] = "G" && 'Table'[Names] = "H", 4,
    BLANK()
)
     

     

    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
2 years ago

 

CalculatedColumn =
SWITCH(
    TRUE(),
    'Table'[Code] = "A" && 'Table'[Names] = "B", 1,
    'Table'[Code] = "C" && 'Table'[Names] = "D", 2,
    'Table'[Code] = "E" && 'Table'[Names] = "F", 3,
    'Table'[Code] = "G" && 'Table'[Names] = "H", 4,
    BLANK()
)
 

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.