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.
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!
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.
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 UA-cam journey. :)
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: ua-cam.com/video/XDrafos4Kn0/v-deo.html
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.
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!
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.
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
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.
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?
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. ua-cam.com/video/pFHC1da4Fk4/v-deo.html
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
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/
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
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.
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 ua-cam.com/video/Qub_vQEh4bM/v-deo.html
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
@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!
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.
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!
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
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
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?
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!
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/
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
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
![DAX BASICS in Power BI Desktop [Part 2]](http://i.ytimg.com/vi/XDrafos4Kn0/mqdefault.jpg)
![DAX BASICS in Power BI Desktop [Part 2]](/img/tr.png)
This is very useful! Thank you!
Hey Quyên Lê, Glad you found it helpful! Keep it up!
Boom! Awesome tutorial, Sir. You master the art of teatching! Keep it up
Glad to hear my content was helpful. Boom💥
easy to understand measurements formulas. Thank you Nestor. Keep going!🎉
Glad you found the tutorial helpful. Cheers!
Awesome,Clearly explained and easy to understand.Thanks!
Thanks for your feedback 👍
with your teaching style and the perfect examples. Thank you one more time!
Keep up the great work, Jairo.
Absolutely thankful I came across this tutorial. Well done, Nestor!
Glad it was helpful. Keep it up, Adejoke Adeoye!
This is a great intro to DAX--thank you, Nestor!
Glad you like it. Cheers!
Thanks Nestor ! your tutorials are very helpful and you explain everything in detailed manner ::)
Shreyashi, thanks for stopping by. Keep up the great work!
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.
Great to hear! Keep it up, Mahaa👍
This is great stuff Nestor...many many thanks
Thanks for your support, Benjamin Franklin. Keep it up 👍
Great! Explanation is very clear.thanks a lot!
Glad you found the content helpful, Sathish!
Very well explained!
Glad it was helpful!
Thanks!
Thanks for your support, Ken! Keep it up 👍
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!
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.
@@norpriest521 Appreciate your kind words and I will add Hierarchy to my list. Keep up the good work!
Great video,
Before I was confused during my training,
Your video explanation is full clarity to understand
Thank you for uploading Video. 😊
Glad it was helpful! 👍 Keep up the great work, Shiva Kumar Gampa!
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 UA-cam journey. :)
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: ua-cam.com/video/XDrafos4Kn0/v-deo.html
Thank you. Very helpful for someone starting out in Power BI.
Glad you found the content helpful. Keep up the good work, Abe Woodrum! Cheers!
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.
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!
Excellent with detailed explanation
Glad 😀 you found it helpful, Marie song!
Nestor. I just want to know that you are the BEST!
Excellent! Glad you found it helpful.
Gracias Nestor un video muy didactico. felicidades
Gracias Diego. Esta es la versión en español por si la deseas revisar también. Saludos👍
really awesome explanation,will follow next videos for sure.
Awesome, thank you!
Thanks, i look forward to watching the rest of your videos on powerbi and dax
Excellent! Keep up the good work, Randy.
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.
Thanks for your feedback, Andrew aa! If you haven't done so, you might want to take a look at part 2. ua-cam.com/video/XDrafos4Kn0/v-deo.html
Nice basics Nestor.
Glad it was helpful! Keep up the good work, Gelbert!
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
Excellent, Guru Singh! Glad it was helpful. Keep it up!
Have watched several h long videos about DAX in order to find what you have shown during the first 3 minutes in your video
Glad you found it helpful, Kudratilla, Keep it up!
Great tuitorial :)
Thank you! Cheers!
Nice job on the tutorial. Well presented.
Glad it helped! keep up the good work, unfrail!
Awesome video, BOOM!
Thanks for stopping by. Keep it up!
Nestor respect. Love the boom factor:)
Thanks for your support, Luca. Keep it up!👍
Thank you, really nice video.
Glad you liked it!👍
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.
Glad you found the content helpful! Keep up the great work, Venkat M.
Thank you Nestor excellent work!
Glad you found it helpful, Giorgos! Keep up the good work.
Thanks Nestor. Very Helpful Video
Glad it was helpful! Keep up the good work.
Great stuff. Thank You for sharing!!!
Jason, glad it was helpful. Keep it up! 👊
How to make a column containing values of a particular year as date , so as to put growth rate formula
For grow rate, you might want to take a look at this tutorial. Cheers! ua-cam.com/video/6vJIAJNTdG0/v-deo.html
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?
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. ua-cam.com/video/pFHC1da4Fk4/v-deo.html
Love it when he says "Boom" everytime something works! Lol
Thanks for stopping by, Nain Shafi. Keep up the great work! Boom💥💥💥
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
🤔
Y -1 we have write on last of the dax can explain
Raja, Thanks for stopping by. Could you please share more details about your question so I can guide better?
Excellent presentation. Thank you. Is there a spreadsheet that i can down load for parctising.
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/
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
Mana, Thanks for your support. Could you please share more details about what you are trying to achieve so I can guide you better?
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.
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 ua-cam.com/video/Qub_vQEh4bM/v-deo.html
Great tutorial
Aakash, glad you found it helpful. Keep it up!
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
@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!
Brilliant!!! keep going on!
Thank you! Will do!
thank you for sharing ✔
No problem 👍 Glad you found the content helpful, Aboubakr!
Nice 👍
Excellent, Raj. Keep up the good work. Cheers
Wow nice video
Thanks for your feedback. Cheers👍
Boom :)
Hope you are enjoying the content, Neelesh!
Thanks Boom!
Glad you found the content helpful!👍
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.
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!
Awesome!
Glad you found it helpful!
Everything is awesome buddy, but where can we get the dataset to practice ourselves?
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
@@NestorAdrianzen Really appreciate your response good sir :) Thank you!
Which book is suitable DAX beginner
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
Really awesome video. By any chance, can you share the details of Data2 table? Perhaps best if I can download it.
Thanks for stopping by, Jae K. There should be a link to the data in the video description.
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?
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!
@@NestorAdrianzen thank you
Amazing!
Glad it was helpful. Keep it up, Raj!
Simple and easy
Thanks for your feedback, Jignesh!
Nice video
Can u plz share data documents
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/
@@NestorAdrianzen thanks you so much
you helped me lot..
if possible do one end to end project on powerbi ..good luck Nestor
Boom!!!
Haha. I hope you are enjoying the content, Akarsh!
Nestor Adrianzen yeah mate jokes aside , great content! Loving it! 👍🏻
Boom
Thanks for stopping by, Supreme Nnn!
Thanks sir
Glad it was helpful. Keep it up, Deepak!
@@NestorAdrianzen ,Très utile, merci beaucoup Monsieur Nestor
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
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
@@NestorAdrianzen Thankyou so much :)
3:00
por favor en castellano, gracias
Saúl, gracias por revisar el contenido. Esta es la versión en español. Saludos ua-cam.com/video/KpQ1zdAw_TU/v-deo.html
Gracias. 👍
Cómo veo los tutoriales en castellano que todos me salen en inglés dentro tu canal amigo.
Boom!
Vinayak, Glad it was helpful! Boom!💥