Conditional Column in Power BI using Power Query You can do anything

There are many scenarios that you might want to implement a conditional expression. When the conditional expression's logic is on a row-by-row basis, the best is doing it in Power Query rather than DAX (there are exceptions always), The Add Conditional Column in Power Query is a very helpful option, but often many people find it a bit limited to use. In this video, I'll explain how that works, and how it can be used for any complex scenarios as well.
Read more from my blog article here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

[brotov]

How can we make conditional column that compare more than 2 columns?

[Griffindor]

Can the values in the else if statement used in the conditional column be dynamic? Based on a changing values of a variable or a table?

[vidushimangal]

Hi Reza, I am at beginner stage of using power bi. Can you please share that what is the difference between adding a column in data model and in power query editor. Does it make any difference in memory needs or performance. thanks

[legendarykingkash]

How do you create a conditional column based on a value string in a column cell?

[ListenurInnerVoice]

Hi i am looking to add greater than and equal to symbol in power bi as single character.help me locating i

[sreekumarmenonk]

Thanks..
but how to add a conditional column inside a nested table? i cant find any resources online!

[ericgriffiths]

How do you take 0-column value if a condition is met

[mutasemfadul]

How can i use a column from another table in the if statement?

[soumenpramanik]

This approach can't work in DirectQuery method ( When connecting PBI Desktop with Databricks)