Blog Post

Power BI Community Blog
3 MIN READ

Conditional Code Branching in Power BI Query: if...then...else => then...else...if

avisingh's avatar
avisingh
Advocate IV
10 years ago
If...Then...Else in a Custom Column We have all used an "if...then...else" statement, when adding a custom column in Power BI query (using Excel Power Query, or Power BI > Get Data). Here is a quick...
Published 10 years ago
Version 1.0
how to
tips & tricks
avisingh's avatar
Advocate IV
Joined March 07, 2016
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
ElenaSSF's avatar
ElenaSSF
Advocate I
1 year ago

Is there any way to prevent execution at all of the unwanted branch?  I'm primarly chasing efficiency with a large file that can come frome one source or another source or both.   So on checking value of a parameter in the dataset I don't want to load the unneeded source at all rather than just not appending it to the output.