How to Write IF STATEMENTS like a PRO in Power BI
Learn how to write IF statements in Power BI and then how to do them BETTER using SWITCH. The SWITCH function can be used instead of IF and in particular scenerios where you have to write NESTED IF statements.
SWITCH basically works by specifying an expression and then if you have multiple values to check, you can return them with something else. When you have conditions this is when we have to use TRUE() after our SWITCH. This allows for more options when using SWITCH to check if our conditions have been met, then returning a result.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -
SUBSCRIBE!
🔴 Don't forget to subscribe: / @transformita
✅ Connect on LinkedIn: / rajausmaanayub
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - -
⌚Timestamps
0:00 Intro
0:35 Basic IF Statement
1:54 Basic Switch
2:48 IF Conditions
3:58 SWITCH conditions
5:15 ORDER MATTERS
7:03 IN - Top Tip