if statement and early exit in m function

[Anonymous]

OK, so say I make a simple function (in the advanced editor):

(test1 as text)=>
let
    if test1 = "yes" then Source = "OK" else Source = "Dang"
in
    Source

This has an error of Token Identifier expeted for the if. What am I doing wrong??

The other thing I was wondering, is if test1 is not equal to "yes", instead of setting source as "Dang", am I able to exit the function with a text string as an error? In most programming languages you just return a value there and it will stop processing the rest of the function, but this doesn't seem an option in Power Query.

[LivioLanzo · Accepted solution]

Hi @Anonymous  - 

the right synthax is:

(test1 as text)=>
let
    Source = if test1 = "yes" then "OK" else "Dang"
in
    Source

for the other question, it depends on what else have in your query, is the function the only code?

[Anonymous]

---

@LivioLanzo wrote:

it depends on what else have in your query, is the function the only code?

---

This function would be called from another function. However, it is only this function I want to exit, and just return an error string. The parent function should continue to process and will just display the error.