Power BI now incorporates Copilot for DAX, as seen in Microsoft Fabric. This Copilot experience is already present in Power BI Desktop. One of its features is the Quick measure suggestions, effective in aiding the creation of DAX measures via natural language rather than from scratch or with templates. This feature streamlines the creation of common DAX measures scenarios, including aggregate columns, count of rows, aggregate per category, mathematical operations, and selected value functions, among others.
To enable Quick measure suggestions users need to navigate to the Options menu of Power BI Desktop and activate the preview switch. Upon activation, users can access the Quick measure suggestions by launching it from the Home or the Modeling tab of the ribbon. Users describe the measure they want to create, then press Generate (or enter key) to receive DAX measure suggestions. After validation, users can add the suggested measures to their model.
The feature also supports natural language examples for each measure scenario. The supported aggregation includes sum, count, distinct count, distinct counts excluding blanks, average, min, max, median, variance, and standard deviation.
Power BI has been improving its usability and accessibility with features like Copilot for DAX. This feature anticipates the need of less tech-savvy users, offering them an accessible way to create DAX measures. Once understood and implemented, Copilot is an effective tool that can ease and speed up the process of working with data in Power BI. It further demonstrates Microsoft's commitment to making data analysis and visualizations more user-friendly.
Power BI has Copilot, which provides DAX capabilities. With Copilot, users can use natural language to generate DAX measures such as aggregated columns, count of rows, aggregated per category, mathematical operations, selected value, if condition, text operations, time intelligence, relative time filtered value, most/least common value, top N filtered value, top N values for a category, and information functions. To use the feature, users need to navigate to the Options menu of Power BI Desktop and enable the preview switch for Quick measure suggestions.
After enabling the preview, users can access the Quick measure suggestions by launching it from the Home or Modeling tab and selecting Suggestions. They can then describe the measure they want to create and hit Generate to get DAX measure suggestions. It is important to validate the DAX suggestions to make sure it meets the user's needs before adding it to the model. Examples of natural language for each of the supported measure scenarios include sum of sales, total sales, count products, unique users, max price, and median age. For aggregated columns, users can also specify one or more optional filters.
Microsoft Copilot, Power BI Desktop, Quick measure, DAX measure, Natural language processing, Measure suggestions