Write DAX queries with Copilot
Try using Copilot to create a DAX query. Type in a prompt to describe what DAX query you would like generated and select Send or press Enter. To run what is returned, select Keep it to add it to query tab. Then select Run or press F5 to see the results of the DAX query.
DAX query features in Copilot
Let’s look at what Copilot can help you with in DAX query view:
- Natural language to DAX query. Just ask for what you want from your semantic model and have the DAX query generated by Copilot.
- DAX query to natural language. Ask Copilot to explain what any DAX query is doing.
- Understand DAX concepts. Maybe you heard about a certain DAX function or need to find the right DAX function for the job. Copilot can help you here too.
Enable Copilot for DAX queries
In Power BI Desktop, in the Preview features section of the Options, enable DAX query view with Copilot.
Check to make sure you meet the Fabric Copilot requirements.
Then navigate to the DAX query view and select the Copilot button or CTRL+I to launch the in-line Copilot.
Let’s try some Copilot prompts, using sample data in Power BI Desktop, with some additional measures.
Use Copilot to write and explain DAX queries
With DAX query view in Power BI, 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.
Copilot can write and explain DAX queries in DAX query view in public preview. DAX query view includes an inline Fabric Copilot to write and explain DAX queries, which remain in public preview.
Note
DirectQuery model authors can also use DAX query view. View the data in your tables whenever you want.
Sample prompts for writing DAX queries
Here is a collection of sample prompts to illustrate how to get Copilot to write the DAX queries you want.
- List products and show the last three months' profit compared to the previous three months.
- Add a column to show the difference.
- Explain what this query does.
- What is SUMMARIZECOLUMNS used for.
List products and show the last three months' profit compared to the previous three months
In a blank query tab, invoke Copilot with CTRL+I and enter this request:
"list the products and show the last 3 months profit compared to the 3 months before."
After a few moments I get a detailed DAX query.
I select Keep it and then Run the query.
Let's see the difference between the last three months and the previous three months. Select the query and start Copilot again with CTRL+I, or select the ribbon button.
Add a column to show the difference
This time the selection is showing fitted to the text and the background shading highlights what is being sent with the request to Copilot.
Now the diff styling in the DAX query editor shows exactly what Copilot has changed.
I select Keep it and Run it again.
I see the DAX query, and I can see the requests I sent to Copilot at the top of the query. Each main block of the query is also commented, explaining what it’s doing in each part.
Maybe those comments aren't working for me. Let’s get a full explanation.
Explain what this query does
Again, highlight the whole query and invoke Copilot with this request:
"Explain to me what this query does."
Now, instead of writing DAX queries, it’s responding in the in-line window.
Copilot generates a few lines. I select Show more to see the full explanation.
Now I understand each part and the DAX functions used.
What is SUMMARIZECOLUMNS used for?
Speaking of these DAX functions, it would be great to get an explanation of those too. Let’s try Copilot to get some more information about a specific DAX function.
In this request, let’s find out what the SUMMARIZECOLUMNS does.
Again, Copilot generates brief description:
I select Show more.
Because I asked Copilot in the context of a DAX query that I highlighted, it gave me the response in the context of that query as well.