Forum Discussion

bhargavanand's avatar
bhargavanand
Helper 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 = D then 2,

if Code = E and Name = F then 3,

if Code = G and Name = H then 4

 

 

 

How can I implement this in Power BI?


Thanks in advance.

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.

2 Replies

  • foodd's avatar
    foodd
    Community 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.

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    Hello bhargavanand .   Thank you for finding my suggestion a Solution for your need.  Please hit the LIKE 👍 button if it has helped you.