How to use the IF & SWITCH DAX Functions in Power BI // Beginners Guide to Power BI in 2021
Get Demo Files here
https://ko-fi.com/s/9013867971
In this video we go through how you can start using the IF DAX function in Power BI to handle logical tests and take your reports to the next level.
We go through the basics step by step, we also touch on how to build nested if statements, and how you can use the SWITCH DAX function to make your code even more readable.
-
🚩 Support us to get perks such as demo files, early access and more!
https://www.patreon.com/solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - https://amzn.to/3ruYs2f
📗 DAX Patterns - https://amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - https://amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - https://amzn.to/3q04QOw
🪑 Infamous Gaming Chair - https://amzn.to/3q3iUXw
💡 LED Studio Lighting - https://amzn.to/3q3ftQz
🎙 Lavalier Microphone - https://amzn.to/3jwKutG
📺 Monitor - https://amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - https://www.linkedin.com/company/solutionsabroad
📘 Facebook - https://www.facebook.com/solutionsabroad
📸 Instagram - https://www.instagram.com/solutions_abroad
🐤 Twitter - https://twitter.com/AbroadSolutions
🤖 Reddit - https://www.reddit.com/user/fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
https://youtu.be/iHzlIML-vWs
🗺 Learn DAX to extend your Power BI calculations
https://youtube.com/playlist?list=PLa370_-deBCS5Kj3wMnhQjc-a8yznueHC
📆 Stay up-to-date on all the features Power BI releases monthly
https://youtube.com/playlist?list=PLa370_-deBCTu1VvH58zzPNC7mHSF4KvX
🧪 Get certified as a Microsoft Data Analyst Associate
https://youtube.com/playlist?list=PLa370_-deBCSTVsrfawVhU5Oitoi5hEWa
💡 Learn Power BI Features to improve your dashboards
https://youtube.com/playlist?list=PLa370_-deBCQZ1kmob-KIVlBihwCOfG53
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
https://powerbi.microsoft.com/en-us/downloads/
#PowerBI #DataAnalytics #BusinessIntelligence
Видео How to use the IF & SWITCH DAX Functions in Power BI // Beginners Guide to Power BI in 2021 канала Fernan
https://ko-fi.com/s/9013867971
In this video we go through how you can start using the IF DAX function in Power BI to handle logical tests and take your reports to the next level.
We go through the basics step by step, we also touch on how to build nested if statements, and how you can use the SWITCH DAX function to make your code even more readable.
-
🚩 Support us to get perks such as demo files, early access and more!
https://www.patreon.com/solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - https://amzn.to/3ruYs2f
📗 DAX Patterns - https://amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - https://amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - https://amzn.to/3q04QOw
🪑 Infamous Gaming Chair - https://amzn.to/3q3iUXw
💡 LED Studio Lighting - https://amzn.to/3q3ftQz
🎙 Lavalier Microphone - https://amzn.to/3jwKutG
📺 Monitor - https://amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - https://www.linkedin.com/company/solutionsabroad
📘 Facebook - https://www.facebook.com/solutionsabroad
📸 Instagram - https://www.instagram.com/solutions_abroad
🐤 Twitter - https://twitter.com/AbroadSolutions
🤖 Reddit - https://www.reddit.com/user/fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
https://youtu.be/iHzlIML-vWs
🗺 Learn DAX to extend your Power BI calculations
https://youtube.com/playlist?list=PLa370_-deBCS5Kj3wMnhQjc-a8yznueHC
📆 Stay up-to-date on all the features Power BI releases monthly
https://youtube.com/playlist?list=PLa370_-deBCTu1VvH58zzPNC7mHSF4KvX
🧪 Get certified as a Microsoft Data Analyst Associate
https://youtube.com/playlist?list=PLa370_-deBCSTVsrfawVhU5Oitoi5hEWa
💡 Learn Power BI Features to improve your dashboards
https://youtube.com/playlist?list=PLa370_-deBCQZ1kmob-KIVlBihwCOfG53
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
https://powerbi.microsoft.com/en-us/downloads/
#PowerBI #DataAnalytics #BusinessIntelligence
Видео How to use the IF & SWITCH DAX Functions in Power BI // Beginners Guide to Power BI in 2021 канала Fernan
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Use DRILLTHROUGHS to show data details in Power BI // Beginners Guide to Power BI in 2021](https://i.ytimg.com/vi/Zx_CWTQ4gdo/default.jpg)
![ADVANCED SYNC SLICER options and how they work in POWER BI // A Power BI Basics Guide on Slicers](https://i.ytimg.com/vi/_SLtLfk0OME/default.jpg)
![POWER QUERY GET DATA IN REPORT BUILDER! Paginated Reports Experience, Limitations and Considerations](https://i.ytimg.com/vi/HPwPPkkBiQE/default.jpg)
![4 Different Ways to Default your Reports to TODAY // Beginners Guide to Power BI in 2021](https://i.ytimg.com/vi/pt7dI8af_m8/default.jpg)
![Prepare the Data - Profile your data - DA-100 Exam Preparation Series for 2020](https://i.ytimg.com/vi/wk2l8edz0Y8/default.jpg)
![Create a SIMPLE EXPENSES TRACKER using GOOGLE SHEETS connected to Power BI // Power BI 2023 Guide](https://i.ytimg.com/vi/XrBJPg4I698/default.jpg)
![How to create and customise FORECAST LINES in Power BI // Beginners Guide to Power BI in 2021](https://i.ytimg.com/vi/MrIwuAVGYR8/default.jpg)
![Anomaly Detection, Zoom Sliders AND MORE from Power BI November 2020 Feature Update](https://i.ytimg.com/vi/CWGq4KPm8ho/default.jpg)
![NEW! Power BI March 2023 Features, IN-OBJECT FORMATTING, APPLY FILTERS, AND MORE / Power BI News](https://i.ytimg.com/vi/OLqPduHkgsk/default.jpg)
![KEYBOARD SHORTCUTS to write DAX quickly and easily // Beginners Guide to Power BI in 2022](https://i.ytimg.com/vi/04NIrKt_c-Q/default.jpg)
![Azure Maps, IF.EAGER and MORE from Power BI March 2021 Update](https://i.ytimg.com/vi/PCRkLo1ZZxU/default.jpg)
![MY TOP 5 POWER BI 2023 FEATURES // Top Features that took my Dashboards to the NEXT LEVEL](https://i.ytimg.com/vi/ZGycvQSazrc/default.jpg)
![DECEMBER 2023 UPDATE // Classic Mode for On Object Interaction, Bar Chart Styling AND MORE](https://i.ytimg.com/vi/D2daqT0Np-s/default.jpg)
![Introduction to TMDL (Tabular Model Definition Language) // What is it? TMSL vs TMDL // Quick Guide](https://i.ytimg.com/vi/EJ4cTuUc3so/default.jpg)
![EMBED Power BI Reports into PowerPoint // Beginners Guide to Power BI in 2022](https://i.ytimg.com/vi/oihfr-SGsJE/default.jpg)
![QUICK LOOK AT NEW LAYOUTS for MATRIX VISUALS in Power BI // Beginners Guide to Power BI](https://i.ytimg.com/vi/0ayocHM36Ko/default.jpg)
![Find the SAFEST Borough in London with POWER BI - Step by Step](https://i.ytimg.com/vi/N5vvZUmgXek/default.jpg)
![HOW TO JOIN DATA // How to use SEMI JOINS // Beginners Guide to using MERGE and RELATIONSHIPS](https://i.ytimg.com/vi/EaGMSNq9OWc/default.jpg)
![Sparklines, Hybrid Tables AND MORE // Power BI December 2021 Feature Summary Update](https://i.ytimg.com/vi/bv1yBdeVp1s/default.jpg)
![QUICK MEASURES, DEPLOYMENT HISTORY AND MORE// PBI October 2022 Feature Summary and update](https://i.ytimg.com/vi/ej_XeFQGPMA/default.jpg)
![APRIL 2024 POWER BI UPDATE // 100% Stacked Area Chart, Auto Refreshing PowerPoint AND MORE](https://i.ytimg.com/vi/rlFk1pL-Z7w/default.jpg)