564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
|Using a DAX query to show a table in Power BI|
|Did you know that you can write an EVALUATE DAX query in software like DAX Studio and then run it from within Power BI to create a new table? You do now!|
-- list out a set of rows
-- show all the purchases made in London
-- with an additional column showing the town name
-- group by the town name ...
-- ... and show total quantity
When you execute this DAX query, it lists out data from a Power BI data model:
The query shows results like this.
You now want to show this as a table in a Power BI report. To do this, use the New Table button:
You can find this New table button on the Modeling tab of the ribbon.
Paste in your DAX query, excluding the EVALUATE command at the start:
Your query should now return a table of data in Power BI.
This shows the same table of information!
You can now treat this as any other table in Power BI.
I would guess that this technique might be useful for people who know the DAX querying language but aren't as familiar with Query Editor.
25 Aytoun Street