Need to create column based on conditions on values of two separate column

[HarpalsinhZala]

Hi Folks,

I need your help, I am new to this platform.

I have data source of sharepoint list.

Here i give you a short explaination about my database.

I have table that contains columns channel,asset type,asset number. I want to create column based on perticular channel and perticular asset type.  Please have a look at below table.

Channel	Asset Type	Asset Number
test	a	15
zee	b	25
lee	c	19
lee	a	10
alem	alem	58
lee	a	45
alem	alem	85
test	b	05

1) now i want to create a new column: Column A that contains number of asset only for asset type a or b. for which i use following 

logic in custom column:

if [asset type] = a or [asset type]=b then [asset number] else null.

2) I want to create another column that contains asset number only for which have channel and asset type both as "alem".

 i used following logic

  if [channel] = "alem" then if [asset type] = "alem" then [asset number] else 0 else null.

Please help to resolve it. 

[v-shex-msft · Accepted solution]

HI @HarpalsinhZala,

You can try to create a calculated column with the below formula if it meets your requirement:

Replaced =
IF (
    table[channel] = "alem",
    IF ( table[asset type] = "alem", table[asset number], 0 )
)

Regards,

Xiaoxin Sheng

[Fowmy]

@HarpalsinhZala 

Can you try this : 
(This is in Power Query)

if [channel] = "alem" and [asset type] = "alem" then [asset number] else 0

[HarpalsinhZala]

Hi @Fowmy 

Thanks for solution, but sorry it's not working.

please help me with another alternative.