iferror in M Language

[Jocelyn]

hi , 

i wanted to apply this excel formula to M language. 

Iferror (if (Non captive amount.amount <> 0, usd@planrate helpcell2, if( noncaptive amount.amount = 0 , usd@planrate helpcell1. usd@planrate help...

how do i change it correctly? 

Thanks

[selimovd · Accepted solution]

Hey @Jocelyn ,

you didn't close the bracket of the ifs.

Close them and I think it should work.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[v-yalanwu-msft · Accepted solution]

Hi, @Jocelyn ;

The conditional format formula of M language is written as follows:

if [Non Captive Amount.amount] <>null then [#"USD@planrate helpce112"]
else if [Non Captive Amount.amount] =null then [#"USD@planrate helpce111"] 
else null

in addition, here it is recommended that the column name in power Query do not have #"".

Or you could add conditional column in power query .

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Jocelyn Parenthesis are unnecessary as is second 'each'.

[selimovd · Accepted solution]

Hey @Jocelyn ,

you didn't close the bracket of the ifs.

Close them and I think it should work.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Jocelyn]

May i know why it will have this "function" here

Supposely, all should be numbers or null.