From the course: Power BI Copilot Tips and Troubleshooting

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Writing DAX queries

Writing DAX queries

From the course: Power BI Copilot Tips and Troubleshooting

Start my 1-month free trial Buy for my team

Writing DAX queries

“

- [Instructor] DAX, short for data analysis expressions is the formula language that we use to create tables, columns, and measures in our Power BI semantic model. The DAX query view lets us create DAX queries directly within Power BI without having to rely on outside tools. It works on semantic models with imported data or with a live connection. In the DAX query view, copilot can use the context of the tables, columns, and measures in the semantic model to suggest queries that we can run, as well as to write and explain them for us. We'll start by navigating to the DAX query view in Power BI Desktop. There's already a sample query in the middle of the page where we can write DAX query formulas. We can access copilot by selecting its icon next to the code, or by choosing the copilot button from the top ribbon. The copilot prompt now appears in our DAX query view space instead of a chat panel on the right. The prompt window gives us some ideas as prompts for suggesting measures…

Contents