Загрузка страницы

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
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
2 апреля 2021 г. 20:00:01
00:13:55
Другие видео канала
Use DRILLTHROUGHS to show data details in Power BI // Beginners Guide to Power BI in 2021Use DRILLTHROUGHS to show data details in Power BI // Beginners Guide to Power BI in 2021ADVANCED SYNC SLICER options and how they work in POWER BI // A Power BI Basics Guide on SlicersADVANCED SYNC SLICER options and how they work in POWER BI // A Power BI Basics Guide on SlicersPOWER QUERY GET DATA IN REPORT BUILDER! Paginated Reports Experience, Limitations and ConsiderationsPOWER QUERY GET DATA IN REPORT BUILDER! Paginated Reports Experience, Limitations and Considerations4 Different Ways to Default your Reports to TODAY // Beginners Guide to Power BI in 20214 Different Ways to Default your Reports to TODAY // Beginners Guide to Power BI in 2021Prepare the Data - Profile your data - DA-100 Exam Preparation Series for 2020Prepare the Data - Profile your data - DA-100 Exam Preparation Series for 2020Create a SIMPLE EXPENSES TRACKER using GOOGLE SHEETS connected to Power BI // Power BI 2023 GuideCreate a SIMPLE EXPENSES TRACKER using GOOGLE SHEETS connected to Power BI // Power BI 2023 GuideHow to create and customise FORECAST LINES in Power BI // Beginners Guide to Power BI in 2021How to create and customise FORECAST LINES in Power BI // Beginners Guide to Power BI in 2021Anomaly Detection, Zoom Sliders AND MORE from Power BI November 2020 Feature UpdateAnomaly Detection, Zoom Sliders AND MORE from Power BI November 2020 Feature UpdateNEW! Power BI March 2023 Features, IN-OBJECT FORMATTING, APPLY FILTERS, AND MORE / Power BI NewsNEW! Power BI March 2023 Features, IN-OBJECT FORMATTING, APPLY FILTERS, AND MORE / Power BI NewsKEYBOARD SHORTCUTS to write DAX quickly and easily // Beginners Guide to Power BI in 2022KEYBOARD SHORTCUTS to write DAX quickly and easily // Beginners Guide to Power BI in 2022Azure Maps, IF.EAGER and MORE from Power BI March 2021 UpdateAzure Maps, IF.EAGER and MORE from Power BI March 2021 UpdateMY TOP 5 POWER BI 2023 FEATURES // Top Features that took my Dashboards to the NEXT LEVELMY TOP 5 POWER BI 2023 FEATURES // Top Features that took my Dashboards to the NEXT LEVELDECEMBER 2023 UPDATE // Classic Mode for On Object Interaction, Bar Chart Styling AND MOREDECEMBER 2023 UPDATE // Classic Mode for On Object Interaction, Bar Chart Styling AND MOREIntroduction to TMDL (Tabular Model Definition Language) // What is it? TMSL vs TMDL // Quick GuideIntroduction to TMDL (Tabular Model Definition Language) // What is it? TMSL vs TMDL // Quick GuideEMBED Power BI Reports into PowerPoint // Beginners Guide to Power BI in 2022EMBED Power BI Reports into PowerPoint // Beginners Guide to Power BI in 2022QUICK LOOK AT NEW LAYOUTS for MATRIX VISUALS in Power BI // Beginners Guide to Power BIQUICK LOOK AT NEW LAYOUTS for MATRIX VISUALS in Power BI // Beginners Guide to Power BIFind the SAFEST Borough in London with POWER BI - Step by StepFind the SAFEST Borough in London with POWER BI - Step by StepHOW TO JOIN DATA // How to use SEMI JOINS // Beginners Guide to using MERGE and RELATIONSHIPSHOW TO JOIN DATA // How to use SEMI JOINS // Beginners Guide to using MERGE and RELATIONSHIPSSparklines, Hybrid Tables AND MORE // Power BI December 2021 Feature Summary UpdateSparklines, Hybrid Tables AND MORE // Power BI December 2021 Feature Summary UpdateQUICK MEASURES, DEPLOYMENT HISTORY AND MORE// PBI October 2022 Feature Summary and updateQUICK MEASURES, DEPLOYMENT HISTORY AND MORE// PBI October 2022 Feature Summary and updateAPRIL 2024 POWER BI UPDATE // 100% Stacked Area Chart, Auto Refreshing PowerPoint AND MOREAPRIL 2024 POWER BI UPDATE // 100% Stacked Area Chart, Auto Refreshing PowerPoint AND MORE
Яндекс.Метрика