Thinking about your DAX Queries like a SQL Query in Power BI

Coming to Power BI with SQL experience? Trying to learn DAX? Patrick shows you how to think about your DAX Queries like a SQL Query in Power BI. We hope this helps you to create DAX Queries that are much more accurate and effective!


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #DAX #GuyInACube

[eziola]

Amazing! Do a whole playlist on DAX Queries. I think it is the most effective way to learn DAX / think in DAX! Thank you and keep em coming!

[gerryboy]

Brilliant. What would be even better is if we could use an actual SQL query directly thus be able to leverage all that SQL expertise.

[PeteBlake-hv]

Thank you Patrick, explaining how to handle that pesky "Query(1, 1) The expression specified in the query is not a valid table expression" message. This was driving me nuts 'cause I didn't understand why it was occurring and wasn't able to find good explanation for it. Made my day. Thanks again.

[mwaltercpa]

So many benefits to this. I love that it’s in the app… I can build in the view, then materialize as a new dim table. It’s also a great way to learn DAX, and simplify the work your measures have to do in the report :) Love it.

[jurakovtun]

Wow, unbelievable quality of the video. The design, transitions and of course, the host! Thank you so much for your work! ❤

[soy_leche]

Would be interested to learn more on this in a slower and more detailed format. This seems to be a lot more complex than SQL for the same queries but would be good to know this.

[thomasivarsson]

Braces {} are important i noticed. Code with light colour on a light background.

[simonvaughan]

Amazing stuff Patrick, I always learn something new from each of your videos

[Herr_Vorragender]

Upfront; I have never used PowerBI.
And so I'm sitting here thinking why would I want yet another syntax to "replace" SQL?
Maybe it's better or faster somehow. Or maybe I can't use SQL in PowerBI. But in the latter case, whouldn't it have been wiser to integrate the classic SQL syntax into PowerBI?
I bet it has something to do with the other DAX capabilities.

[StephanieNelson-zm]

AH HA moment!! I've been having trouble with DAX because I think in SQL...this connects the dots for sure!

[GaryThomann-CoGC]

Thank <higher being> for dax studio. If you want to display a list of measures then use the following construct
EVALUATE {
CONVERT( MAX( 'table'[measure] ), STRING ) & UNICHAR(10) &
CONVERT( MAX( 'table'[measure] ), STRING )
}

[jessesmith]

The timing of this video was uncanny. Thanks so much for this.

[RobertLJ]

Thank you for the video. This video came right on time. I am attempting to make the mental jump from SQL to DAX and this video is a great help. I'm looking forward to any other trips or tricks you post in the future. 👍🎉🎁

[KoundinyaPulipaka]

Please let me know after getting the results. What should we do, is it only for analysis if we can utilize the results.

[georgebob]

Awesome video. This has sparked my mind to figure out new ways to use the power of DAX!

[lopypop]

Can you do another video using M like a SQL query? (Power Query is the place I'm most likely to think about data in terms of querying vs DAX is where I'm thinking about building measures)

[melodym]

Thank you!! It's getting close to transact SQL!! AWESOME!!!😊

[dbszepesi]

I really don't want to talk about how long I have been using Rows() instead of just using the table constructor '{}' that I just learned about in this video.

[ElderCruz]

It would be awesome if someday in the future you could create DAX notebooks integrated in Power BI Desktop, just like Jupyter Notebooks with Python or similar to RStudio

[kostaskolotouros]

Awesome video. Planning to use DAX Studio more often, so thank you!