DAX Basics in Power BI Desktop [Part 1]

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

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

50% 1

DAX Basics in Power BI Desktop/
In this tutorial, we will be learning about DAX basics in Power BI Desktop. We will go from what is DAX to creating visualizations with these calculated columns and measures.
Please navigate through the content below:
0:22 Content
0:32 What is DAX?
0:51 Pre-requisites
1:16 Simple syntax
2:03 Complex syntax
3:45 Functions
4:11 Function categories in DAX
4:47 Creating calculated columns
9:10 Creating calculated measures
12:20 How to edit a measure
13:37 Creating a visualization
Bonus:
16:23 How to create a table for measures:
Data link: drive.google.com/file/d/1PftM...
Data Source: gapminder.org/data/
___________
Highly recommended Power BI books (Affiliate links):
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: amzn.to/3ldPLpk
***DAX Patterns (Second Edition): amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: amzn.to/3fDPLOd
***Beginning DAX with Power BI: amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice!: amzn.to/36c6Cot
***Information Dashboard Design: amzn.to/2V61o7h
___________Relevant PBI Topics
- MEASURES vs CALCULATED COLUMNS in DAX: • MEASURES vs CALCULATED...
- How to Use the ALL DAX Function in Power BI: • How to Use the ALL DAX...
- How to Use the Filter DAX Function in Power BI [The Basics]: • How to Use the Filter ...
- How to Calculate PERCENTAGES in Power BI: • How to Calculate PERCE...
- How to COMBINE Tables in Power BI: • How to COMBINE Tables ...
____________
[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.
--------------------
If you like the content, feel free to buy me a cup of coffee 😀👇www.paypal.me/vizxlization
If you don't want to miss anything, subscribe to our newsletter: vizxlization.com/welcome-to-v...
___________Please follow us on:
Web: www.vizxlization.com/
LinkedIn: / vizxlization
Twitter: / vizxlization
Facebook: / vizxlization
Instagram: / nestoradrianzen
Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!
#DAX #PowerBIDAX #PowerBItutorial #vizxlization

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

10 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@QuyenLe-rp8rb 3 года назад

This is very useful! Thank you!

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

Hey Quyên Lê, Glad you found it helpful! Keep it up!

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

with your teaching style and the perfect examples. Thank you one more time!

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

Keep up the great work, Jairo.

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

So useful for a beginner like myself. I was overwhelmed when I read about DAX and I was like this is going to be tough but this seems to possible with some practice. Thankyou Nestor.

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

Great to hear! Keep it up, Mahaa👍

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

Absolutely thankful I came across this tutorial. Well done, Nestor!

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

Glad it was helpful. Keep it up, Adejoke Adeoye!

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

Thanks Nestor ! your tutorials are very helpful and you explain everything in detailed manner ::)

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

Shreyashi, thanks for stopping by. Keep up the great work!

@petecardona8203 Год назад

easy to understand measurements formulas. Thank you Nestor. Keep going!🎉

@NestorAdrianzen Год назад

Glad you found the tutorial helpful. Cheers!

@SMITDEDHIA96 4 года назад

Hi Nestor! Thanks for this video. To your question - I find using variables, leveraging relationships to use RELATED() function, looking up values, using IF() & allied functions very easy. At the same time, the I find Table functions and understanding filter & row context quite challenging.

@NestorAdrianzen 4 года назад

Smit, thanks for sharing your thoughts about DAX. I agree! some DAX functions are quite straightforward but other functions are challenging as well. It seems that you are on track. Keep up the good work!

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

Have watched several h long videos about DAX in order to find what you have shown during the first 3 minutes in your video

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

Glad you found it helpful, Kudratilla, Keep it up!

@osoriomatucurane9511 5 месяцев назад

Boom! Awesome tutorial, Sir. You master the art of teatching! Keep it up

@NestorAdrianzen 5 месяцев назад

Glad to hear my content was helpful. Boom💥

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

This is a great intro to DAX--thank you, Nestor!

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

Glad you like it. Cheers!

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

Thank you. Very helpful for someone starting out in Power BI.

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

Glad you found the content helpful. Keep up the good work, Abe Woodrum! Cheers!

@SowmiKitchen123 7 месяцев назад

Awesome,Clearly explained and easy to understand.Thanks!

@NestorAdrianzen 7 месяцев назад

Thanks for your feedback 👍

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

Thanks, i look forward to watching the rest of your videos on powerbi and dax

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

Excellent! Keep up the good work, Randy.

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

This is great! For beginners like me, it's a little harder to grasp DAX, esp with measures and calculated columns but I am getting hang of it. And the bonus!! I saw atleast 3 full courses yet none came up with it. Thankyou. Subscribed! I wish you good luck on your RU-vid journey. :)

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

Sushmita Joshi, thanks for your feedback. Dax is an interesting journey. If you haven’t seen the second version of this tutorial, here is the link: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XDrafos4Kn0.html

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

Great video, Before I was confused during my training, Your video explanation is full clarity to understand Thank you for uploading Video. 😊

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

Glad it was helpful! 👍 Keep up the great work, Shiva Kumar Gampa!

@giorgosi.fovakis8810 3 года назад

Thank you Nestor excellent work!

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

Glad you found it helpful, Giorgos! Keep up the good work.

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

Gracias Nestor un video muy didactico. felicidades

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

Gracias Diego. Esta es la versión en español por si la deseas revisar también. Saludos👍

@hermerbalan82 4 года назад

Thanks Nestor. Very Helpful Video

@NestorAdrianzen 4 года назад

Glad it was helpful! Keep up the good work.

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

Great! Explanation is very clear.thanks a lot!

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

Glad you found the content helpful, Sathish!

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

This is great stuff Nestor...many many thanks

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

Thanks for your support, Benjamin Franklin. Keep it up 👍

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

Amazing information I really loved the simple and effective way It was communicated , immediately subscribed , please add more project specific videos on power bi kind of case studies

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

Excellent, Guru Singh! Glad it was helpful. Keep it up!

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

Nestor. I just want to know that you are the BEST!

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

Excellent! Glad you found it helpful.

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

Great stuff. Thank You for sharing!!!

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

Jason, glad it was helpful. Keep it up! 👊

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

Thank you. The lesson is very well sequence and presentation very clear. Appreciated it alot. Hope you could create more video to illustrate other DAX functions.

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

Thanks for your feedback, Andrew aa! If you haven't done so, you might want to take a look at part 2. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XDrafos4Kn0.html

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

Very well explained!

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

Glad it was helpful!

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

Nice job on the tutorial. Well presented.

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

Glad it helped! keep up the good work, unfrail!

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

Awesome video, BOOM!

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

Thanks for stopping by. Keep it up!

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

Brilliant!!! keep going on!

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

Thank you! Will do!

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

really awesome explanation,will follow next videos for sure.

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

Awesome, thank you!

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

Excellent with detailed explanation

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

Glad 😀 you found it helpful, Marie song!

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

Thank you, really nice video.

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

Glad you liked it!👍

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

Nestor respect. Love the boom factor:)

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

Thanks for your support, Luca. Keep it up!👍

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

Amazing!

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

Glad it was helpful. Keep it up, Raj!

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

Hello Nestor, Your video on Basic / frequently used DAX formulas are very helpful. You explained it well. Please Tag whether if you have created new videos on DAX. Thank you.

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

Glad you found the content helpful! Keep up the great work, Venkat M.

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

Thanks Boom!

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

Glad you found the content helpful!👍

@kenm2342 Год назад

Thanks!

@NestorAdrianzen Год назад

Thanks for your support, Ken! Keep it up 👍

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

Awesome!

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

Glad you found it helpful!

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

thank you for sharing ✔

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

No problem 👍 Glad you found the content helpful, Aboubakr!

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

Great tutorial

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

Aakash, glad you found it helpful. Keep it up!

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

Great tuitorial :)

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

Thank you! Cheers!

@NestorAdrianzen 4 года назад

What's up, everybody! Question. What has been the easiest and most challenging part of Dax so far? Please let me know by leaving a comment below. Cheers!

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

Thank you for this great video. You summed up almost everything people should know to use power bi the right way. Personally, this should be the first video people need to watch before they get to work with power bi EVER. Additionally, I would like to suggest that if you can add Hierarchy into this video, it would be awesome.

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

@@norpriest521 Appreciate your kind words and I will add Hierarchy to my list. Keep up the good work!

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

Nice basics Nestor.

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

Glad it was helpful! Keep up the good work, Gelbert!

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

Simple and easy

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

Thanks for your feedback, Jignesh!

@neeleshtanwar 4 года назад

Boom :)

@NestorAdrianzen 4 года назад

Hope you are enjoying the content, Neelesh!

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

Love it when he says "Boom" everytime something works! Lol

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

Thanks for stopping by, Nain Shafi. Keep up the great work! Boom💥💥💥

@RajendraPatel. 3 года назад

Nice 👍

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

Excellent, Raj. Keep up the good work. Cheers

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

Excellent presentation. Thank you. Is there a spreadsheet that i can down load for parctising.

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

Jagath, Glad it helped! Here you go: Data link: drive.google.com/file/d/1PftMb_PcfAtgwv4J9y2R3PfAs8-kxIZa/view?usp=sharing Data Source: gapminder.org/data/

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

Boom!!!

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

Haha. I hope you are enjoying the content, Akarsh!

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

Nestor Adrianzen yeah mate jokes aside , great content! Loving it! 👍🏻

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

Boom!

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

Vinayak, Glad it was helpful! Boom!💥

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

Thanks sir

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

Glad it was helpful. Keep it up, Deepak!

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

@@NestorAdrianzen ,Très utile, merci beaucoup Monsieur Nestor

@yummyyummy3432 Год назад

Wow nice video

@NestorAdrianzen Год назад

Thanks for your feedback. Cheers👍

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

Boom

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

Thanks for stopping by, Supreme Nnn!

@alka_true.0 3 года назад

Amazing tutorial! Is there any website or any platform where we have live projects in power BI we can practice? Specially ones with extensive use of DAX

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

Alka, Thanks for stopping by and I'm glad that you found this tutorial helpful. Regarding live projects, you might want to take a look at the Power BI community. There is a section about real life DAX questions. I hope it helps! See the link below. community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands

@alka_true.0 3 года назад

@@NestorAdrianzen Thankyou so much :)

@csrajaraman 4 года назад

Hi.. is there a concept of arrays in Dax? I have table with unique set of tasks performed by an employee each week. The tasks keeps varying. I have to display each task performed by the employee in separate display visual. Can you please help?

@NestorAdrianzen 4 года назад

Raj, Thanks for your question. I'm not familiar with your dataset, but it seems that the CALCULATE function can be your best ally here. You might want to check the following tutorial out If you haven't done so. I hope it helps. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pFHC1da4Fk4.html

@user-dj5xj6ed5z Год назад

Hi Nestor, I am trying to work out a DAX to work out the percentage of 0s,1,s,2s,3s and 4s in a column. The DAX I have been using ignores the 0s. Do you have any suggestions? Many thanks

@NestorAdrianzen Год назад

🤔

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

Thank you! Just a question, do you know how to retrieve a column from another table? Can you please help? I need to calculate the total price, however the quantity in the order table, the price in the product table, how can I do this, please help, I spent a few hours, could not figure it out. Thank you so much.

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

Cindy, thanks for stopping by. Have you tried creating relationships between these two tables? By doing so, you can get data from another table. If this doesn’t work, you might want to combine those two tables. This tutorial will help. Cheers ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Qub_vQEh4bM.html

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

Really awesome video. By any chance, can you share the details of Data2 table? Perhaps best if I can download it.

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

Thanks for stopping by, Jae K. There should be a link to the data in the video description.

@islam48ify 4 года назад

Can we translate this fonction: >> AVG= calculate ([average Population], data2[year] >2000) To >> if the year is > 2000 then calculate the average of the population that have year> 2000.

@NestorAdrianzen 4 года назад

Mohand, Good question. It seems that we can also find the same result by using the CALCULATE function. See below: ------- AVG = CALCULATE ( AVERAGE (TableName[Population]), FILTER( ALL(TableName[Year]), TableName[Year] > 2000 ) ) --------- You can replace "TableName" for the right name of your table. Let me know if it works! Thanks!

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

How to make a column containing values of a particular year as date , so as to put growth rate formula

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

For grow rate, you might want to take a look at this tutorial. Cheers! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6vJIAJNTdG0.html

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

Everything is awesome buddy, but where can we get the dataset to practice ourselves?

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

Nilav, Thanks for stopping by. I usually share the content links in the video description of each video. Here are the links for reference: drive.google.com/file/d/1PftMb_PcfAtgwv4J9y2R3PfAs8-kxIZa/view drive.google.com/file/d/1PftMb_PcfAtgwv4J9y2R3PfAs8-kxIZa/view

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

@@NestorAdrianzen Really appreciate your response good sir :) Thank you!

@88pianissimo90 3 года назад

I am SAP BW/4 HANA consultant and usually BW systems have huge amounts of data. Backend cubes have on an average 10 million records..... will Power BI give good performance with such huge data? I read some blogs which says that Tableau works faster than Power BI if backend data volume is huge..... is that true?

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

88 Pianissimo, Thanks for stopping by. Large amounts of data would definitely demand more processing time. However, in Power BI, there are good practices that can help us improve performance. Among those practices are the following: use measures instead of calculated columns, use variables, create a calendar table within the date ranges of the model, etc. I cannot talk much about Tableau performance, since I don't have a lot of experience using that tool yet. But I have heard great things about performance as well. I hope it helps. Cheers!

@88pianissimo90 3 года назад

@@NestorAdrianzen thank you

@RajaSekhar-lz2km 2 года назад

Y -1 we have write on last of the dax can explain

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

Raja, Thanks for stopping by. Could you please share more details about your question so I can guide better?

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

Sir it's really good but give the example means for suppose sum function is there how to get calculate the sum valus in the data show the formula in the value sir please how to the explain it

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

Mana, Thanks for your support. Could you please share more details about what you are trying to achieve so I can guide you better?

@rallabandasatish6415 Год назад

Hi Nestor, i have requirement like this i have a name column like A,B,C and brand column like AMS,CW,MYC. A is taken AMS and CW brands, Bis taken AMS and MYC brands, C is taken CW and MYC brands . Now i want to show these in a power bi slicer. if i select AMS brand in a slicer i want to show the both A and B names but how to do, i have only one table will you please help me

@NestorAdrianzen Год назад

@rallabandasatish, Thanks for stopping by. If you add brand in your slicer and then filter it for a specific brand, the filter should work fine. If it's now working properly, perhaps you might want to check if the data is clean and well-formatted before you start creating your visualizations in Power BI. For that task, you can use Power Query within Power BI Desktop. I hope that helps. Cheers!

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

Which book is suitable DAX beginner

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

Azam, Thanks for stopping by. You might want to check the following list of books for reference: mailchi.mp/c2d83799d3fd/highly-recommended-books-to-master-power-bi

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

Nice video Can u plz share data documents

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

Tejas Reddy, Glad you found the content helpful! I usually share the content links in the video description of each tutorial. See below for reference: Content Link: drive.google.com/file/d/1PftMb_PcfAtgwv4J9y2R3PfAs8-kxIZa/view?usp=sharing Data Source: gapminder.org/data/

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

@@NestorAdrianzen thanks you so much you helped me lot.. if possible do one end to end project on powerbi ..good luck Nestor