Copilot DAX query features

DAX query view comes with several ways to help you be as productive as possible with DAX queries. You can use Copilot to write and explain DAX queries in DAX query view with Data Analysis Expressions (DAX) queries in semantic models. DAX query view comes with several ways to help you be as productive as possible with DAX queries. This feature is currently in public preview. See Use Copilot to write and explain DAX queries.

Note

DirectQuery model authors can also use DAX query view. View the data in your tables whenever you want.

Quick queries

Have the DAX query written for you from the context menu of tables, columns, or measures in the Data pane of DAX query view. Get the top 100 rows of a table, statistics of a column, or DAX formula of a measure to edit and validate in just a few clicks.

Create and edit measures

Edit one or multiple measures at once. Make changes and see the change in action in a DA query. Then update the model when you are ready. All in DAX query view.

See the DAX query of visuals

Investigate the visuals DAX query in DAX query view. Go to the Performance Analyzer pane and choose Run in DAX query view.

Write DAX queries

You can create DAX queries with Intellisense, formatting, commenting/uncommenting, and syntax highlighting. And additional professional code editing experiences such as “Change all occurrences” and block folding to expand and collapse sections. Even expanded find and replace options with regex.

Learn more about DAX queries with Copilot with these resources.