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

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.

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

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

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.

Fantastic......Simply Fantastic

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!

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!

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

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

Hi Avi... its been awhile... thank you...

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

Thank you for❤ sharing the knowledge