BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Posted by Andy Brown on 14 January 2021
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Using a DAX query to show a table in Power BI
-- 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.