Подія
Чемпіонат світу з даних Power BI
14 лют., 16 - 31 бер., 16
Маючи 4 шанси увійти, ви можете виграти пакет конференції і зробити його на live Grand Finale в Лас-Вегасі
ДокладноЦей браузер більше не підтримується.
Замініть його на Microsoft Edge, щоб користуватися перевагами найновіших функцій, оновлень безпеки та технічної підтримки.
Quick measure suggestions assist creation of DAX measures using natural language instead of using templates or writing DAX from scratch. Quick measure suggestions with Copilot feature are no longer available in public preview.
This feature can be used to jump-start creation of common DAX measures scenarios, such as:
To enable the feature, navigate to the Options menu of Power BI Desktop and turn on the preview switch for Quick measure suggestions. This feature can be used to jump-start creation of common DAX measures scenarios such as:
To enable the feature, you need to first navigate to the Options menu of Power BI Desktop and turn on the preview switch for Quick measure suggestions:
After you have enabled the feature, you can access the Quick measure suggestions, by launching Quick measure from the Home or Modeling tab of the ribbon and selecting Suggestions:
Here you can describe the measure you want to create and hit Generate (or enter key) to get DAX measure suggestions:
You should always validate the DAX suggestions to make sure they meet your needs. If you’re satisfied with a suggested measure, you can click the Add button to automatically add the measure to your model.
To help demonstrate the feature here are some natural language examples for each of the supported measure scenarios.
Apply aggregations to a column to return a single value. Our supported aggregations include sum, count, distinct count, distinct count no blanks, average, min, max, median, variance, and standard deviation.
Examples:
For aggregated columns, you can also specify one or more filter conditions. If there are multiple filter conditions, you can specify if you want an intersection (&&/AND) or union (||/OR) of the filters.
Examples:
Count the number of records in the specified table. You don’t need to specify the table if there is only one table.
Examples:
For row counts, you can also specify one or more filter conditions. If there are multiple filter conditions, you can specify if you want an intersection (&&/AND) or union (||/OR) of the filters.
Examples:
Compute a measure for each distinct value in a category and then aggregate the results to return a single value. Our supported aggregates include average, weighted average, min, max, variance.
Examples:
Perform mathematical operations with numeric columns, measures, or aggregated columns. For scenarios across columns within a table, you can either average (AVERAGEX) or sum up (SUMX) the result in order to return a single value.
Examples:
Get the selected value of a column. This is typically used when paired with a single-select slicer or filter so that the measure returns a non-blank value.
Examples:
Return values based on conditions. If you are returning string values, you need to use double quotes. Conditions can use the following comparison operators: =, ==, <>, <, >, <=, >=
Examples:
Perform text operations with columns, measures, or aggregated columns. For scenarios across columns within a table, we’ll merge (CONCATENATEX) the result in order to return a single value.
Examples:
These time intelligence scenarios require using a properly marked date table or auto date/time hierarchy. For YTD scenarios you can specify "fiscal" or "fiscal calendar" to base the calculation on the fiscal calendar (ends on June 30th).
Examples:
Apply a relative time filter that filters your measure or aggregated column to the last N hours / days / months / years.
Examples:
Return the value with the most or least number of occurrences in a specified column.
Examples:
Compute a measure or aggregated column that is filtered to the top N categorical values based on that same measure or aggregated column.
Examples:
Get a concatenated list of the top N values within a column based on a measure or aggregated column.
Examples:
Return system or user information such as the current date/time or the current user's email, domain, or username.
Examples:
Here you can describe the measure you want to create and hit Generate (or enter key) to get DAX measure suggestions:
You should always validate the DAX suggestions to make sure they meet your needs. If you’re satisfied with a suggested measure, you can click the Add button to automatically add the measure to your model.
To help demonstrate the feature here are some natural language examples for each of the supported measure scenarios.
Apply aggregations to a column to return a single value. Our supported aggregations include sum, count, distinct count, distinct count no blanks, average, min, max, median, variance, and standard deviation.
Examples:
For aggregated columns, you can also specify one or more filter conditions. If there are multiple filter conditions, you can specify if you want an intersection (&&/AND) or union (||/OR) of the filters.
Examples:
Count the number of records in the specified table. You don’t need to specify the table if there is only one table.
Examples:
For row counts, you can also specify one or more filter conditions. If there are multiple filter conditions, you can specify if you want an intersection (&&/AND) or union (||/OR) of the filters.
Examples:
Compute a measure for each distinct value in a category and then aggregate the results to return a single value. Our supported aggregates include average, weighted average, min, max, variance.
Examples:
Perform mathematical operations with numeric columns, measures, or aggregated columns. For scenarios across columns within a table, you can either average (AVERAGEX) or sum up (SUMX) the result in order to return a single value.
Examples:
Get the selected value of a column. This is typically used when paired with a single-select slicer or filter so that the measure returns a non-blank value.
Examples:
Return values based on conditions. If you are returning string values, you need to use double quotes. Conditions can use the following comparison operators: =, ==, <>, <, >, <=, >=
Examples:
Perform text operations with columns, measures, or aggregated columns. For scenarios across columns within a table, we’ll merge (CONCATENATEX) the result in order to return a single value.
Examples:
These time intelligence scenarios require using a properly marked date table or auto date/time hierarchy. For YTD scenarios you can specify "fiscal" or "fiscal calendar" to base the calculation on the fiscal calendar (ends on June 30th).
Examples:
Apply a relative time filter that filters your measure or aggregated column to the last N hours / days / months / years.
Examples:
Return the value with the most or least number of occurrences in a specified column.
Examples:
Compute a measure or aggregated column that is filtered to the top N categorical values based on that same measure or aggregated column.
Examples:
Get a concatenated list of the top N values within a column based on a measure or aggregated column.
Examples:
Return system or user information such as the current date/time or the current user's email, domain, or username.
Examples:
Подія
Чемпіонат світу з даних Power BI
14 лют., 16 - 31 бер., 16
Маючи 4 шанси увійти, ви можете виграти пакет конференції і зробити його на live Grand Finale в Лас-Вегасі
ДокладноНавчання
Модуль
Add measures to Power BI Desktop models - Training
In this module, you'll learn how to work with implicit and explicit measures. You'll start by creating simple measures, which summarize a single column or table. Then, you'll create more complex measures based on other measures in the model. Additionally, you'll learn about the similarities of, and differences between, a calculated column and a measure.
Сертифікація
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Продемонструйте методи та практичні поради, які відповідають бізнес-вимогам і технічним вимогам для моделювання, візуалізації та аналізу даних за допомогою Microsoft Power BI.
Документація
Learn DAX basics in Power BI Desktop - Power BI
Learn about how to effectively use DAX basics in Power BI Desktop to solve real business problems for your organization.
Formula editor in Power BI Desktop - Power BI
Learn how to use keyboard shortcuts to create and edit Data Analysis Expressions (DAX) formulas in Power BI Desktop.
Model view in Power BI Desktop - Power BI
Learn how you can use Model view in Power BI Desktop to visualize the tables, column, and complex relationships in your model.