Power BI: How to Write any DAX Measure In Just 3 Easy Steps 👣

[@danyos777]

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).

[@LeviewFPV]

this is one of the best insights I've seen and NO ONE IS SAYING THIS.

[@jay6817]

Thanks. This helped

[@mindyqi3705]

Hi Avi, great video and really good explanation! I am always impressed by your ability to make complicated things way much easier to understand!❤

[@MhLiMz]

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 ([e-mail]) 👉 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 ([e-mail]) 👉 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 [e-mail] 👉 Ask Power BI Questions: www.LearnPowerBI.com/question 👉 Get Power BI Training: www.LearnPowerBI.com/training

[@hemanthbachu]

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-po1ji7ru3t]

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: [e-mail]

[@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.

[@jay6817]

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 [e-mail] 👉 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-h9j]

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 [e-mail] 👉 Ask Power BI Questions: www.LearnPowerBI.com/question

[@jay6817]

I'm a logical person. This has confused me completely. I must be unusual. 😅

[@innis17]

Holy shit this could have been a 5 min video.

[@faizalahmed46]

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?

[@PowerBIPro]

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

[@HalaMadridKM9]

why are you killing people time.