Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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.
Hello @bhargavanand . Thank you for finding my suggestion a Solution for your need. Please hit the LIKE 👍 button if it has helped you.
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.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |