7:15- Nested IF's- delete the else argument from your first IF statement and enter your next IF. 11:04- a second nested IF 11:40- SWITCH statement 13:19- What the SWITCH statement looks like
Could you please let me know what is the video called about: "List Of Iterator Functions in Power BI/DAX"? you mention it in this video. Thanks a lot for your helpful videos and good job
Great question! I generally use SWITCH statements because they are a lot cleaner to write than IF statements. However if you want to add more expressions (or extra conditions) on any of the branches, from my experience you can only do that with nested ifs.
Original Data Parent Child 1. Group A 1. Group A a a b b c c Hello, With the Original Data I have to bifurcate like Parent and Child. In excel I have used formula like =IF (RIGHT(TRIM(LEFT(A2,3)),1)=".","",A2). Also I used same king in power BI for New column but that column was not showing in Transform Data. I want to have separate columns Parent and Child which can show under Transform Data. Please suggest
7:15- Nested IF's- delete the else argument from your first IF statement and enter your next IF.
11:04- a second nested IF
11:40- SWITCH statement
13:19- What the SWITCH statement looks like
Fernan you know the art of teaching. Thank you for simple yet detailed video !. Much appreciated your efforts !!
This is what I was looking for, thanks!
Could you please let me know what is the video called about:
"List Of Iterator Functions in Power BI/DAX"?
you mention it in this video.
Thanks a lot for your helpful videos and good job
Thank you for your job.
That helps a lot to understand how clean can be your writes.
Also, Can you please share your data.
Thnx a lot.
Thanks Nasir! All the files can be downloaded from my Patreon: www.patreon.com/posts/demo-files-52538104
Thank you for the video it helped me with the If formula for a audit i am working on. Very helpful fix the error. 👍👍
Thanks for this interesting video? Does "Switch" also work with "> < = .." ?
Excellent video!! Could you make a video with "IF" with "AND" with fields in 3 tables that have relationships? Thanks!!
Excellent tips !! thanks so much for haring !!
Great job! Just take some keyboard with lower sound of keys :)
Thanks for the tip!
Amazing video, thanks so much
Thanks Fernan for the amazing content.
Very helpful video
Many thanks for sharing this
Hi why I can’t do IF with Left calculations in BI?
This is very helpful! Quick question though, what is the advantage of using an IF statement if using SWITCH is easier and cleaner to use?
Great question! I generally use SWITCH statements because they are a lot cleaner to write than IF statements. However if you want to add more expressions (or extra conditions) on any of the branches, from my experience you can only do that with nested ifs.
@@SolutionsAbroad Yes if condition is single, then switch is best but for mutliple conditons we have to use nested ifs.
Original Data Parent Child
1. Group A 1. Group A
a a
b b
c c
Hello, With the Original Data I have to bifurcate like Parent and Child. In excel I have used formula like =IF (RIGHT(TRIM(LEFT(A2,3)),1)=".","",A2). Also I used same king in power BI for New column but that column was not showing in Transform Data. I want to have separate columns Parent and Child which can show under Transform Data. Please suggest
Brilliant
Great to see you again Eyitayo
@@SolutionsAbroad Yeah! You are right. Glad to be back again
Eu te amo