How to use the IF & SWITCH DAX Functions in Power BI // Beginners Guide to Power BI in 2021

Подписаться 49 тыс.

Просмотров 46 тыс.

50% 1

Get Demo Files here
ko-fi.com/s/90...
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!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / 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 RU-vid.
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
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 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
powerbi.micros...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@arpitmalviya6234 Год назад

Fernan you know the art of teaching. Thank you for simple yet detailed video !. Much appreciated your efforts !!

@thobilebhengu8318 4 месяца назад

Thank you for the video it helped me with the If formula for a audit i am working on. Very helpful fix the error. 👍👍

@greatcookin 2 года назад

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.

@SolutionsAbroad 2 года назад

Thanks Nasir! All the files can be downloaded from my Patreon: www.patreon.com/posts/demo-files-52538104

@Eveluna-gm6es Год назад

This is what I was looking for, thanks!

@lolalola8421 Год назад

Excellent video!! Could you make a video with "IF" with "AND" with fields in 3 tables that have relationships? Thanks!!

@theluckyone2005 Год назад

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

@GeraBizuneh Год назад

Excellent tips !! thanks so much for haring !!

@eagillum Год назад

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

@abdulfatahal-shammeri6575 Год назад

Amazing video, thanks so much

@atinshola Год назад

Very helpful video Many thanks for sharing this

@nebojsanedeljkovic1272 2 года назад

Great job! Just take some keyboard with lower sound of keys :)

@SolutionsAbroad 2 года назад

Thanks for the tip!

@jawadahmadehssan6251 2 года назад

Thanks Fernan for the amazing content.

@1973youness 10 месяцев назад

Thanks for this interesting video? Does "Switch" also work with "> < = .." ?

@EyiBillion 2 года назад

Brilliant

@SolutionsAbroad 2 года назад

Great to see you again Eyitayo

@EyiBillion 2 года назад

@@SolutionsAbroad Yeah! You are right. Glad to be back again

@jozsuacruz3341 3 года назад

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?

@SolutionsAbroad 3 года назад

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.

@arpitmalviya6234 Год назад

@@SolutionsAbroad Yes if condition is single, then switch is best but for mutliple conditons we have to use nested ifs.

@RodolfoJrGalit 2 года назад

Hi why I can’t do IF with Left calculations in BI?

@luizfernandoryuseikaykomi6441 Год назад

Eu te amo

@shreenathayachit507 Год назад

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