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

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.

==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

================================
#PowerBI #PowerBIHowTo #PowerBIPro

===Most Popular Playlists===

⚡Power On!⚡
-Avi Singh

[danyos]

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

[mindyqi]

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

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

[julliettecarignan]

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!

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

[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

[funriderhoermi]

I love the way you explain things, even you're speaking very fast sometimes 🙂

[jeffkasavan]

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

[jay]

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.

[reevapatel]

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

[diamondsandlipgloss]

this is helpful...im still working on understanding ... thank you

[pabeader]

Where do [Sales YoY] and [Sales YoY%] come from?

[jay]

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

[innis]

Holy shit this could have been a 5 min video.

[faizalahmed]

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?