The beauty of understanding SQL scripts helps to understand the sequence of the DAX scripts. In fact, FILTERS are the innermost sub-queries that are executed first and applied to its subsequent inner query that is enclosing the FILTER statement. The CALCULATE function is the inner query, and the SUMX is the outer query that has the main enclosing statement grouping all the other functions and queries. Power BI is similar to SQL in that it queries data starting from the innermost statements (functions) all the way up to the outer query or function. The outer function requires all the data from the functions enclosed in it (it becomes the enclosing statement for the rest of the functions).
Great video and explanation of the X functions, Avi! I had never really thought of them as a iterators that work their way backwards, but it makes complete sense now! Thanks!
Hey @Wilkstep glad you enjoyed that. What did you think about CALCULATE working Outside -> In. Until I understood that, I kept getting in trouble with CALCULATE. Ha! Actually I still get in trouble sometimes, but far less now. Power On! / Avi (avi@avising.com) 👉 Ask Power BI Questions: www.LearnPowerBI.com/question 👉 Get Power BI Training: www.LearnPowerBI.com/training
@@PowerBIPro same thing happens to me with CALCULATE as well sometimes. Lol. Funny thing: even though I know it's not the same thing, both it and the X functions somewhat remind me of how my old reverse polish notation HP11c calculator worked. Haha! Thanks again for the great video!
Great video, and simple way of solving this, but I have learned the 80-20 rule differently: in 80% of your time with a software, you'll only need 20% of it can do.
Glad to help @lakshminarayana3168 and thank you 🙏 for being a subscriber. Power On! / Avi avi@avising.com 👉 Ask Power BI Questions: www.LearnPowerBI.com/question 👉 Get Power BI Training: www.LearnPowerBI.com/training
Good points here, Avi. Reflecting on how I've approached DAX problems, I can see how it would've helped if I'd first made my thinking more cyrstal clear about what the DAX would have to do at each step. Thank you!
Hey Juliette, yeah I think we discount our "Human" skill :-) That's been my experience, once I slowed myself down enough...I am usually able to figure out the DAX (or even Power Query). You do need a basic set of Power BI skills, but far less than I had imagined. To this day, I have helped lots and lots of people are there are only like 5-6 DAX Functions that I use frequently (and if you know the core concepts, you can just Google the rest of the stuff- as I often do. But *without* the core concepts, Google/TH-cam can be frustrating). Power On! / Avi (avi@avising.com) 👉 Ask Power BI Questions: www.LearnPowerBI.com/question 👉 Get Power BI Training: www.LearnPowerBI.com/training
Hi, Avi - at 6:12 you mention that "humans are smarter than machines" - I used to remind people who struggle with computers "The computer can only count to 1". That seemed to help calm their anxiety.😁
Ha! Sorry about that (speaking fast!). I tend to do that, when I get excited about something...and Power BI often gets me very excited :-) Feel free to change the speed in TH-cam to 0.75x if needed. All our videos also have Captions with them, that you can also turn on (that often helps me in following better). If you need additional help, please check out: 👉 Ask Power BI Questions: www.LearnPowerBI.com/question 👉 Get Power BI Training: www.LearnPowerBI.com/training Power On! / Avi Email: avi@avising.com
Cool. Here are some links that may help you in your Power BI journey. 👉 Ask Power BI Questions: www.LearnPowerBI.com/question 👉 Get Power BI Training: www.LearnPowerBI.com/training Power On! / Avi
Hey @Nancmadi Yeah, I got a severe case of "Imposter" syndrome and that led to me stopping to create much new content. I am (mostly) over that now...that gripping fear that I had (that I don't know enough) is still there, but I have learned to focus on those who I can serve 💛. And that's always been the Beginner, the Business-User and the Non-Techie. That's who I am at heart, and even though I may not be a Power BI Expert, I can still help people. I am also looking to co-create my Power BI Advance Program. 👉 Check out www.LearnPowerBI.com/advanced if interested (or curious). Power On! / Avi avi@avising.com 👉 Ask Power BI Questions: www.LearnPowerBI.com/question 👉 Get Power BI Training: www.LearnPowerBI.com/training
Hi! Is there a way to import data from multiple SQL Servers in the same query? Example - I need to select columns a and b from db1 that sits on server1 and columns x and y from db6 that sits on server2. How do I do this - select columns a, b, x, y FROM server1.db1 Left Join server2.db6 ON a = X.
Hey @Pabeader1941, Good point, I kinda skipped over that in my video. I should have at least pointed to where you can learn more. Sales YoY and Sales YoY% are pretty standard Time Intelligence calculation. Right now, the best place I can point you to learn that (and a whole host of other Time Intelligence cool stuff) is my LearnPowerBI Training program. See link below. 👉 Get Power BI Training: www.LearnPowerBI.com/training Power On! / Avi avi@avising.com 👉 Ask Power BI Questions: www.LearnPowerBI.com/question
Yeah except Power BI has been a complete waste of all my time. Should have just stuck with Excel since time is the one thing I don’t have. Power BI is a complete waste of time for 95% of people that could just do it in Excel in a fraction of the time.
Surprisingly, you have never shown the input data table(s) that DAX used to apply those functions. This should have been the very first thing to show to your audience. How do you expect people will understand your lesson if they can only imagine how the input data tables look like ? This is what DAX uses, tables, with their rows and they columns, and/or the relationships between tables, if your data model contains more than one table. If I had been in your class, I would have stopped you right there. Please show us the data DAX will process, the table(s) that will go down from hundred, maybe thousands of rows to those 4 rows you obtained in the end. You have shown people how the final result should look like (this is fine), but you have never shown where your data story really starts from. Just imagine that this happens for sure on any basic Excel training, people always see the data that are being processed. Personally, I am not happy with this lesson of yours, and I do believe you will use this feedback to make your trainings better and better.
The most confusing channel to learn powerbi.. This channel was my first choice when I started learning.. It had me confusing then. And now after 5 years when I revisited it.. I am still confused with his way of teaching.. Am I the only one who is confused?
Hey Faizal, sorry to hear that. Different people have different styles of learning. I would encourage you to follow the channels that you do find helpful. Wish you the best in your Power BI journey. Power On! / Avi p.s. My focus is to help people get results with Power BI as fast as possible. That is get out of "Learning Mode" and start building real Power BI Projects for their companies and their clients. And our members have had good success through our training. You can see some examples on our Wall of Inspiration learnpowerbi.com/training#wall
The beauty of understanding SQL scripts helps to understand the sequence of the DAX scripts. In fact, FILTERS are the innermost sub-queries that are executed first and applied to its subsequent inner query that is enclosing the FILTER statement. The CALCULATE function is the inner query, and the SUMX is the outer query that has the main enclosing statement grouping all the other functions and queries.
Power BI is similar to SQL in that it queries data starting from the innermost statements (functions) all the way up to the outer query or function. The outer function requires all the data from the functions enclosed in it (it becomes the enclosing statement for the rest of the functions).
this is one of the best insights I've seen and NO ONE IS SAYING THIS.
Thanks. This helped
Please make a video to custom sort in power bi charts as it is a lot complicated when involved calculated columns and grouped columns.
Hi Avi, great video and really good explanation! I am always impressed by your ability to make complicated things way much easier to understand!❤
Great video and explanation of the X functions, Avi! I had never really thought of them as a iterators that work their way backwards, but it makes complete sense now! Thanks!
Hey @Wilkstep glad you enjoyed that. What did you think about CALCULATE working Outside -> In. Until I understood that, I kept getting in trouble with CALCULATE. Ha! Actually I still get in trouble sometimes, but far less now.
Power On! / Avi (avi@avising.com)
👉 Ask Power BI Questions: www.LearnPowerBI.com/question
👉 Get Power BI Training: www.LearnPowerBI.com/training
@@PowerBIPro same thing happens to me with CALCULATE as well sometimes. Lol.
Funny thing: even though I know it's not the same thing, both it and the X functions somewhat remind me of how my old reverse polish notation HP11c calculator worked. Haha! Thanks again for the great video!
Great video, and simple way of solving this, but I have learned the 80-20 rule differently: in 80% of your time with a software, you'll only need 20% of it can do.
Great explanation!😁👍
I'm really impressed by your explanation as well as accent
Fantastic......Simply Fantastic
Thank you for❤ sharing the knowledge
Glad to help @lakshminarayana3168 and thank you 🙏 for being a subscriber.
Power On! / Avi avi@avising.com
👉 Ask Power BI Questions: www.LearnPowerBI.com/question
👉 Get Power BI Training: www.LearnPowerBI.com/training
Good points here, Avi. Reflecting on how I've approached DAX problems, I can see how it would've helped if I'd first made my thinking more cyrstal clear about what the DAX would have to do at each step. Thank you!
Hey Juliette, yeah I think we discount our "Human" skill :-) That's been my experience, once I slowed myself down enough...I am usually able to figure out the DAX (or even Power Query). You do need a basic set of Power BI skills, but far less than I had imagined. To this day, I have helped lots and lots of people are there are only like 5-6 DAX Functions that I use frequently (and if you know the core concepts, you can just Google the rest of the stuff- as I often do. But *without* the core concepts, Google/TH-cam can be frustrating).
Power On! / Avi (avi@avising.com)
👉 Ask Power BI Questions: www.LearnPowerBI.com/question
👉 Get Power BI Training: www.LearnPowerBI.com/training
Hi, Avi - at 6:12 you mention that "humans are smarter than machines" - I used to remind people who struggle with computers "The computer can only count to 1". That seemed to help calm their anxiety.😁
Ha! Love that one @Jeff. "Computers can only count to 1" 😀
Hi Avi, great video and really good explanation! This tutorial really helped me to refresh the basics as well as solving critical DAX calculations
I love the way you explain things, even you're speaking very fast sometimes 🙂
Ha! Sorry about that (speaking fast!). I tend to do that, when I get excited about something...and Power BI often gets me very excited :-) Feel free to change the speed in TH-cam to 0.75x if needed. All our videos also have Captions with them, that you can also turn on (that often helps me in following better).
If you need additional help, please check out:
👉 Ask Power BI Questions: www.LearnPowerBI.com/question
👉 Get Power BI Training: www.LearnPowerBI.com/training
Power On! / Avi
Email: avi@avising.com
this is helpful...im still working on understanding ... thank you
Cool. Here are some links that may help you in your Power BI journey.
👉 Ask Power BI Questions: www.LearnPowerBI.com/question
👉 Get Power BI Training: www.LearnPowerBI.com/training
Power On! / Avi
@@PowerBIPro I know we're in the 21st century, but Excel was much easier imo 😮💨
I have used Quick measures and then mod it to my liking.
Now, I ChatGpt my fields and tell it to build the measure for me. Maybe adjust a tad, also.
Hi Avi... its been awhile... thank you...
Hey @Nancmadi
Yeah, I got a severe case of "Imposter" syndrome and that led to me stopping to create much new content. I am (mostly) over that now...that gripping fear that I had (that I don't know enough) is still there, but I have learned to focus on those who I can serve 💛. And that's always been the Beginner, the Business-User and the Non-Techie. That's who I am at heart, and even though I may not be a Power BI Expert, I can still help people.
I am also looking to co-create my Power BI Advance Program.
👉 Check out www.LearnPowerBI.com/advanced if interested (or curious).
Power On! / Avi
avi@avising.com
👉 Ask Power BI Questions: www.LearnPowerBI.com/question
👉 Get Power BI Training: www.LearnPowerBI.com/training
Hi! Is there a way to import data from multiple SQL Servers in the same query? Example - I need to select columns a and b from db1 that sits on server1 and columns x and y from db6 that sits on server2. How do I do this - select columns a, b, x, y FROM server1.db1 Left Join server2.db6 ON a = X.
Where do [Sales YoY] and [Sales YoY%] come from?
Hey @Pabeader1941,
Good point, I kinda skipped over that in my video. I should have at least pointed to where you can learn more.
Sales YoY and Sales YoY% are pretty standard Time Intelligence calculation.
Right now, the best place I can point you to learn that (and a whole host of other Time Intelligence cool stuff) is my LearnPowerBI Training program. See link below.
👉 Get Power BI Training: www.LearnPowerBI.com/training
Power On! / Avi avi@avising.com
👉 Ask Power BI Questions: www.LearnPowerBI.com/question
I'm a logical person.
This has confused me completely.
I must be unusual. 😅
Holy shit this could have been a 5 min video.
Wasting time
Avi, this is so confusing. Too many words but not enough practical demo. A simple table to follow would be enough and then go step by step.
Too much talking to explain such a simple concept
Yeah except Power BI has been a complete waste of all my time. Should have just stuck with Excel since time is the one thing I don’t have. Power BI is a complete waste of time for 95% of people that could just do it in Excel in a fraction of the time.
Surprisingly, you have never shown the input data table(s) that DAX used to apply those functions. This should have been the very first thing to show to your audience. How do you expect people will understand your lesson if they can only imagine how the input data tables look like ? This is what DAX uses, tables, with their rows and they columns, and/or the relationships between tables, if your data model contains more than one table. If I had been in your class, I would have stopped you right there. Please show us the data DAX will process, the table(s) that will go down from hundred, maybe thousands of rows to those 4 rows you obtained in the end. You have shown people how the final result should look like (this is fine), but you have never shown where your data story really starts from. Just imagine that this happens for sure on any basic Excel training, people always see the data that are being processed. Personally, I am not happy with this lesson of yours, and I do believe you will use this feedback to make your trainings better and better.
The most confusing channel to learn powerbi..
This channel was my first choice when I started learning.. It had me confusing then. And now after 5 years when I revisited it.. I am still confused with his way of teaching..
Am I the only one who is confused?
Hey Faizal, sorry to hear that. Different people have different styles of learning. I would encourage you to follow the channels that you do find helpful. Wish you the best in your Power BI journey.
Power On! / Avi
p.s. My focus is to help people get results with Power BI as fast as possible. That is get out of "Learning Mode" and start building real Power BI Projects for their companies and their clients. And our members have had good success through our training. You can see some examples on our Wall of Inspiration learnpowerbi.com/training#wall
why are you killing people time.