From the course: Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press

Unlock this course with a free trial

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

Apply quick queries and INFO functions

Apply quick queries and INFO functions

From the course: Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press

Start my 1-month free trial Buy for my team

Apply quick queries and INFO functions

“

- The DAX query view allows you to write DAX statements yourself, but it's also possible to use predefined queries as well. These are called quick queries, and we'll show you in this video what you can do with them. Finally, we'll also introduce the INFO functions, which are a special set of DAX functions that provide all kinds of metadata about your model. But first, we'll start with the quick queries. Remember the Data pane at the right of the DAX query view? In the Tables view, you can view all the tables, columns, and measures in your semantic model. You can also right click on any of them to view the special option for quick queries, as shown here in the screenshot. There are different quick queries for tables, for columns, and for measures, which we'll explain in detail in the next few slides. Let's start with the table options. For tables, you have two quick queries available when you right click on the name of a…

Contents