When utilizing SWITCH/True Logic inside of Power BI you really do open up this huge expanse of analytical opportunities.
In this tutorial, I will run through in detail how you need to set up your formulas when using the SWITCH function. This will enable you to find, discover, and visualize many different and interesting insights inside of Power BI.
There are so many different ways that you can utilize SWITCH. It is like a Nested IF statement that you would use in Excel but it’s much more powerful and cleaner.
This is why it’s essential to try and incorporate this into your models if there is an appropriate place to do so.
I’ll show you a range of different ways that you can utilize the SWITCH statement. Once this settles in you’ll immediately see many different other places in your own reports and environments where you can utilize the SWITCH statement.
It’s a really versatile and flexible function that has many great applications within any report that you might be developing right now.
I wish you all the best in learning and implementing this to your own reports and dashboards.
For more advanced analytical techniques you can utilize in Power BI, check out this course module at Enterprise DNA Online – Advanced Analytics in Power BI
Good luck diving into this video tutorial!
***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online