Conditional Column PowerBi Editor

[clarainesgg]

Hi, 

I did a conditional column with one field. However, I need to add another clause AND in the second clause.

if "Name"="gonzalez" then 15754

else if name="perez "and license_1=556 then 885

else Medical_lincense

Thanks!

Clara 

[Jai-Rathinavel · Accepted solution]

Hi @clarainesgg Click on Custom Column and enter the below m code

M Code:

if [name] = "gonzalez" then 15754
else if [name] = "perez" & [license_1] = 556 then 885
else [Medical_license_1]

 M Code snapshot:

Did I answer your question? If yes, please mark my post as a solution.

Thanks,

Jai

[Bibiano_Geraldo · Accepted solution]

Hi @clarainesgg

In power query, on your last step, right and insert step after and in formula bar paste this code:

= Table.AddColumn(PreviousStepName, "Custom Column", each 
    if [Name] = "gonzalez" then 15754
    else if [Name] = "perez" and [license_1] = 556 then 885
    else [Medical_lincense]
)

Replace PreviousStepName with the name of your previous step. If the step name contains spaces or special characters, enclose it in # and double quotes (#"Step Name").

Additionally, ensure you replace the column names (Name, license_1, and Medical_lincense) with the actual column names from your tabl e.

[Anonymous · Accepted solution]

Hi @clarainesgg 

You can also choose to use Dax to meet your needs.

license = IF([Name]="gonzalez",  15754,IF( [Name] ="perez" && [license_1] =556 , 885 ,[Medical_lincense]))

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Bibiano_Geraldo · Accepted solution]

Hi @clarainesgg

In power query, on your last step, right and insert step after and in formula bar paste this code:

= Table.AddColumn(PreviousStepName, "Custom Column", each 
    if [Name] = "gonzalez" then 15754
    else if [Name] = "perez" and [license_1] = 556 then 885
    else [Medical_lincense]
)

Replace PreviousStepName with the name of your previous step. If the step name contains spaces or special characters, enclose it in # and double quotes (#"Step Name").

Additionally, ensure you replace the column names (Name, license_1, and Medical_lincense) with the actual column names from your tabl e.

[Jai-Rathinavel · Accepted solution]

Hi @clarainesgg Click on Custom Column and enter the below m code

M Code:

if [name] = "gonzalez" then 15754
else if [name] = "perez" & [license_1] = 556 then 885
else [Medical_license_1]

 M Code snapshot:

Did I answer your question? If yes, please mark my post as a solution.

Thanks,

Jai