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

Подписаться 201 тыс.

Просмотров 29 тыс.

50% 1

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: ru-vid.com?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

Опубликовано:

11 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 33

@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 5 месяцев назад

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

@jay6817 4 месяца назад

Thanks. This helped

@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!

@mindyqi3705 9 месяцев назад

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

@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/RU-vid 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

@MhLiMz 8 месяцев назад

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.

@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

@musariololade2204 Год назад

Fantastic......Simply Fantastic

@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" 😀

@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 RU-vid 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

@user-po1ji7ru3t 4 месяца назад

Great explanation!😁👍

@hemanthbachu 3 месяца назад

Hi Avi, great video and really good explanation! This tutorial really helped me to refresh the basics as well as solving critical DAX calculations

@jay6817 4 месяца назад

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.

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

@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 😮‍💨

@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