Forum Discussion
Solved
How to force a line to execute in Power Query
I recently posted this question when my query would not refresh correctly. The query would only refresh correctly after I refreshed the preview. To summarise the question and answer, the reason why ...
Hi,
May be,
let
a = "123",
b = "456",
Choose = (chooseFirst as logical, first, second) =>
if chooseFirst then first else second
in
Choose(false, a, b)https://bengribaudo.com/blog/2018/02/28/4391/power-query-m-primer-part5-paradigm
Stéphane
slorin
Super User
Super UserHi,
May be,
let
a = "123",
b = "456",
Choose = (chooseFirst as logical, first, second) =>
if chooseFirst then first else second
in
Choose(false, a, b)
https://bengribaudo.com/blog/2018/02/28/4391/power-query-m-primer-part5-paradigm
Stéphane
- PwerQueryKees
This seems a bit convoluted? Am I missing something? I would do:
let a = "123", b = "456" in if a <> null then b else b
