Power BI: How to Write any DAX Measure In Just 3 Easy Steps 👣
ฝัง
- เผยแพร่เมื่อ 9 พ.ค. 2024
- Are you struggling to write DAX Measures? In this video I explain 3 Simple Steps that Non-Techie Business Users can take to write any DAX Measure.
👉 Get Power BI Training: www.LearnPowerBI.com/training
👉 Get Power BI Advanced Training: www.LearnPowerBI.com/advance
==Table of Contents==
00:00 Intro: Why is DAX Important?
03:02 The DAX Problem
05:50 Step 1 Human Learning 👩
08:40 Step 2: Talk Like a Baby 👶
11:10 Step 3: Machine Learning 🤖
18:11 CALCULATE Function
19:36 Recap Steps
20:57 Your Next Steps to Master Power BI
👉 Download the Power BI files www.LearnPowerBI.com/download
👉 Ask Power BI Questions: www.LearnPowerBI.com/question
👉 Get Power BI Training: www.LearnPowerBI.com/training
👉 Get Power Advance BI Training: www.LearnPowerBI.com/advance
================================
#PowerBI #PowerBIHowTo #PowerBIPro
✅ Subscribe to always get my latest videos: th-cam.com/users/powerbipro?su...
🔴 Ask Questions LIVE on TalkPowerBI www.TalkPowerBI.com
👪 Join our LearnPowerBI Family www.learnpowerbi.com/training
===Most Popular Playlists===
• Power BI Beginner Tutorial: • Power BI Tutorial From...
• Ultimate Calendar: goo.gl/pyki4K
• Power BI Data Modeling and more: goo.gl/WNtJFv
⚡Power On!⚡
-Avi Singh
www.LearnPowerBI.com
www.AviSing.com
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
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 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 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!
Hi Avi, great video and really good explanation! This tutorial really helped me to refresh the basics as well as solving critical DAX calculations
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
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
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" 😀
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.
Fantastic......Simply Fantastic
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.
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
Great explanation!😁👍
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 😮💨
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
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.
why are you killing people time.
Wasting time