cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MicWit Regular Visitor
Regular Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: if statement and early exit in m function

Hi @MicWit  - 

 

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?

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

2 REPLIES 2
Super User
Super User

Re: if statement and early exit in m function

Hi @MicWit  - 

 

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?

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

MicWit Regular Visitor
Regular Visitor

Re: if statement and early exit in m function


@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.