QT#20 - Why switch to SWITCH() - use SWITCH() DAX function in Power BI as an alternative to IF()
Learn how to use the SWITCH() function in DAX as an alternative to the IF() statement. In part 1 of the 2 part series, I'll cover how to use the SWITCH() statement if you want to replace one value with another. In this case a numeric code with a description.
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
https://effectivedashboards.com/power...
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that really do help you, your boss, and your peers make better decisions!
https://effectivedashboards.com/power...
-------------------------
Resources
-------------------------
👉Access to the source PBIX files
https://effectivedashboards.com/cours...
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
https://effectivedashboards.com/data-...