Forum Discussion
Excel Power Query - Stop query if record field does not exist
Anonymous your Source does not look like a record... Anyway, _after in_ instead of res write smth like
if Record.HasFields(your_test_record, "CashField") then name_of_the_last_step else [Ted_Striker_Says = "what a pisser"]. Power Query M is "lazy" so it starts from the end and won't execute subsequent steps if this field is missing.
Anonymous your Source does not look like a record... Anyway, _after in_ instead of res write smth like
if Record.HasFields(your_test_record, "CashField") then name_of_the_last_step else [Ted_Striker_Says = "what a pisser"]. Power Query M is "lazy" so it starts from the end and won't execute subsequent steps if this field is missing.
I see, thank you! Before, i was trying something like: if Record.HasFields(your_test_record, "CashField") = False then <EXIT_QUERY> inside the LET statement... Sounds like my understanding of Power Query M was wrong!
Anonymous order of lines of your code does not matter
let res = if b = 2 then null else c, a = 1, c = a + b, b = 2 in res