Learn DAX Fundamentals in 10 Minutes | Step-by-Step Guide

Learn the fundamentals of DAX expressions in Power BI in just 10 minutes.
🔥 Check out Ahrefs Webmaster Tools for FREE here: ahrefs.com/awt
🆓 DOWNLOAD the FREE dataset for this video: view.flodesk.com/pages/641dbe...
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
In this Power BI DAX tutorial, you learn how to use DAX (data analysis expressions) step by step.
Once we've uploaded the dataset into Power BI, we can start with the expressions. In total, we cover 8 types of expressions. We also cover the difference between a measure and a calculated column. First, we do a simple SUM, then we do a DISTINCTCOUNT, followed by a measure with. multiple functions. Fourth, we use the DIVIDE function, which accounts for divided by zero errors.
Then, we hop into the data view to use calculated columns to calculate the profit and profit margin. Then, we use logical functions like an IF, and a nested IF statement to categorize values. Finally, we use the CALCULATE function to find the revenue filtered by beverage brand.
SOCIALS:
🎬 My Company KZbin Channel: / @careerprinciples
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Intro
0:40​ - SUM Function
1:49​ - DISTINCTCOUNT
3:00​ - Multiple Functions
3:51​ - DIVIDE
6:00 - Concatenate
7:34 - IF Function
8:48 - Multiple IFs
9:54 - CALCULATE
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

[@KenjiExplains]

🔥 Check out Ahrefs Webmaster Tools for FREE here: ahrefs.com/awt

[@alisonmolloy3593]

Kenji, You are a great teacher. Your explanations are clear the pace is perfect for me. Thank you.

[@user-gi3qs9tt3j]

i really appreciate that you appeared on youtube. everything is so clear and easy to follow up :)

[@taniadogra4255]

the first video i watched for power bi. Great one!

[@mohanperera159]

Clear and concise video. Thank you.

[@okonyeolisemeke6764]

You're an amazing teacher.

[@srinivaskashyap2758]

Hi Kenji, that's a great video, I recently finished my training in Power BI. Your videos are great useful to me. I am expecting real time scenarios to gain experience. Thank you, Padmini venkata

[@KenjiExplains]

Awesome! Thank you

[@tachiomarkus6350]

This is fantastic!

[@drob0887]

Thank you so much, you are a blessing.. I can't tell you how much time I wasted watching other videos on Power BI and never got my question answered until now. Your video was straight and to the point, it answered my question and gave me the result I was looking for. Can't wait to watch more of your videos.

[@KenjiExplains]

That's great to hear thank you for watching :)

[@fernandalbm590]

Perfect 👍🏻 thanks 🙏🏻

[@vmckameyjr]

This was excellent ....thank you!

[@pariskhan]

great , would love to see more !

[@bibbib7915]

When I watch Power BI tutorials for beginners, this is what i wanna see. Straight to the point, clear and with simple examples. Your channel has done wonders for my current job ! Thank you :)

[@mausam114]

Thanks for this video. I want to know if there is any way in power BI to archive the reports? Let's say data is getting loaded on a weekly basis, report will get populated with new data every week. so how to access the report that has older data?

[@gul7675]

perfect thanks

[@grazianolocatelli1898]

Great job, thanks!

[@KenjiExplains]

Glad you liked it!

[@talenthub9833]

I really appreciate bro. Love u..❤

[@Gamer_Onnn]

Hi Kenji Great work, Tried to do this but not able to apply IF function for a particular column which is having sigma notation before it. So please advice how to solve this ?

[@amarnathgupta8417]

Hi there is an alternate way to add new columns with conditions, you can simply go to transform data then add column there in add column menu you'll see a conditional column there you can apply these small medium and large categories with ease.

[@jaynebarth2939]

Hi, please how do you calculate the values for females if you have a column where males and females are combined and another column with their respective values? can i generate a VAR here?

[@sreesai4729]

That was very useful 🎉🎉

[@michaelquach6655]

Really great video, DAX is super helpful for todays business and data analysts!!

[@KenjiExplains]

Glad you think so!

[@solomonbhandari-young4154]

Incredible

[@shafiqulsymon5482]

Hi thank for sharing this. Can you please share vedio actual vs budget po😊wer BI dashboard ideas.

[@ShehrozeBahadar]

It's great to Learn Power BI and Excel from you sir, upload more on Power BI, Excell, Power Point love from Pakistan

[@MeStudiosUSA]

Great video and these things are very basic.. to master BI it takes a lot..😅

[@KenjiExplains]

I meant master the fundamentals haha sorry if unclear 😆

[@varunsingh9432]

If I give you data, will you be able to tell/ make a tutorial on that? As I know sales, factory, and cookies data most people use and tell. But real workd data is always different

[@camlex6310]

Great tutorial!

[@KenjiExplains]

Thank you!

[@factsnexts2720]

Sir I am from India ...I want SQL tutorial ... because ur teaching way is very good....if it's possible please do it

[@user-px2eb4hr2b]

Hii Sir can u make complete DAX Function vedio please..

[@raj_patel_43]

Hey, Kenji, We want more videos on PowerBi specifically from you

[@KenjiExplains]

Noted thank you!

[@BenDieselBasicAutomotive]

This is the first time I challenged myself to study DAX. Thank you again,.... Sir...

[@KenjiExplains]

Keep it up!

[@DarkGT]

Great video, very straightforward. Do you have video on the M language too?

[@KenjiExplains]

Cheers! No I dont but will keep it in mind

[@DarkGT]

@@KenjiExplains Thanks. Thank you for your great tutorials.

[@DatawithHimanshu]

Plz make a video on an end to end Power BI report.

[@ruslanazimov8616]

I have a question ,when i create a new column #errors seen in all cells i don't know why if you answer i'll be happy

[@dhruvpatel9957]

far better than udemy course

[@romitrana8631]

Why OR function is used instead of AND to find revenue of Sprite & Fanta?

[@nikhilbhosale8279]

0:39

[@nikhilbhosale8279]

0.39

[@nikhilbhosale8279]

0:00 - 0:39

[@nikhilbhosale8279]

0:00 to 0:39

[@willzinner8813]

can you make dashboard in Power BI video?

[@KenjiExplains]

noted for a future video!

[@nikhilbhosale8279]

0:00 ; 0:39

[@JoeyCbr]

So it should be called DAE then

[@jg7088]

U work for a regional bank? Haha

[@KenjiExplains]

wait what? lol