IF and IF ELSE in power query

[Anonymous]

Hi,

I need a custom column .

I have 2 different status from 2 diferent column.

Active_Status and Inactive_Status.

I need to create a custom column.

When Active_Status = "Active" and Inactive_Status = "Unavaliable" or Inactive_Status ="","Active" ,  Inactive_status = "Unavaliable" and Active_Status= "Active" or Active_Status ="", "Unavaliable".

Please help me.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to the code(Edit the code in "Advanced Editor".).

#"Added Conditional Column" = 
    Table.AddColumn(
        #"Changed Type", 
        "Custom", 
        each if [Active_status] = "Active"  and ([Inactive_Status] = "Unavaliable" or [Inactive_Status] = null)  then "Active" 
        else if ([Active_status] = "Active" or [Active_status] = null) and [Inactive_Status] = "Unavaliable" then "Unavaliable"
        else null
    )

Best regards,
Lionel Chen

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

[amitchandak]

@Anonymous , Try in power query

if [Active_Status] = "Available" then [Active_Status] else if [Inactive_Status] ="Unavailable" then Inactive_Status else null

or

if [Active_Status] = "Available" then [Active_Status] else if [Inactive_Status] ="Unavailable" then Inactive_Status else ""

or

if [Active_Status] = "Available" then [Active_Status] else if [Inactive_Status] ="Unavailable" then Inactive_Status

[Anonymous]

@amitchandak 

Here is the error .

[amitchandak]

@Anonymous or where alternate ways to create columns. Use only one. example

if [Active_Status] = "Available" then [Active_Status] else if [Inactive_Status] ="Unavailable" then Inactive_Status else null

[Anonymous]

@amitchandak 

No all the 3 are not working.