topic Re: fill column based on other column values in DAX Commands and Tips

fill column based on other column values

bhargavanand — Mon, 17 Jun 2024 19:49:37 GMT

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.

Re: fill column based on other column values

foodd — Mon, 17 Jun 2024 20:13:01 GMT

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.

Re: fill column based on other column values

foodd — Tue, 18 Jun 2024 10:53:46 GMT

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