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).
@LeviewFPV7 ай бұрын
this is one of the best insights I've seen and NO ONE IS SAYING THIS.
@jay68175 ай бұрын
Thanks. This helped
@mindyqi370510 ай бұрын
Hi Avi, great video and really good explanation! I am always impressed by your ability to make complicated things way much easier to understand!❤
@MhLiMz10 ай бұрын
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.
@wilkstep Жыл бұрын
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!
@PowerBIPro Жыл бұрын
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
@wilkstep Жыл бұрын
@@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!
@julliettecarignan8563 Жыл бұрын
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!
@PowerBIPro Жыл бұрын
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/KZbin 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
@musariololade2204 Жыл бұрын
Fantastic......Simply Fantastic
@lakshminarayana3168 Жыл бұрын
Thank you for❤ sharing the knowledge
@PowerBIPro Жыл бұрын
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
@hemanthbachu4 ай бұрын
Hi Avi, great video and really good explanation! This tutorial really helped me to refresh the basics as well as solving critical DAX calculations
@user-po1ji7ru3t5 ай бұрын
Great explanation!😁👍
@funriderhoermi Жыл бұрын
I love the way you explain things, even you're speaking very fast sometimes 🙂
@PowerBIPro Жыл бұрын
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 KZbin 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
@jeffkasavan93 Жыл бұрын
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.😁
@PowerBIPro Жыл бұрын
Ha! Love that one @Jeff. "Computers can only count to 1" 😀
@reevapatel8263 Жыл бұрын
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.
@jay68175 ай бұрын
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.
@nancmadi Жыл бұрын
Hi Avi... its been awhile... thank you...
@PowerBIPro Жыл бұрын
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
@diamondsandlipgloss Жыл бұрын
this is helpful...im still working on understanding ... thank you
@PowerBIPro Жыл бұрын
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
@diamondsandlipgloss Жыл бұрын
@@PowerBIPro I know we're in the 21st century, but Excel was much easier imo 😮💨
@jismonGeorge-h9j6 ай бұрын
Wasting time
@pabeader1941 Жыл бұрын
Where do [Sales YoY] and [Sales YoY%] come from?
@PowerBIPro Жыл бұрын
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
@jay68175 ай бұрын
I'm a logical person. This has confused me completely. I must be unusual. 😅
@innis179 ай бұрын
Holy shit this could have been a 5 min video.
@faizalahmed4629 күн бұрын
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?
@PowerBIPro26 күн бұрын
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