fill column based on other column values

[bhargavanand]

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.

[foodd]

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

[foodd · Accepted solution]

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.