Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

if statement and early exit in m function

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.

Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    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?

2 Replies

  • LivioLanzo's avatar
    LivioLanzo
    Solution Sage
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago
      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.