Microsoft Power BI update “Quick measure suggestions” feature in Oct 2022. This feature is in experimental preview for users to test and give feedback.
Quick measure suggestions help us to write a DAX measures using natural language instead of using templates or writing DAX from scratch.
Enable this feature
File > Options & Settings > Option > Preview Features > Turn on Quick measure suggestions. After this restart the Power BI file.
Quick measure Suggestion
Note:- Currently, this feature is only deployed to US datacenters (East US and West US). If your data is outside the US, the feature will be disabled by default unless your tenant admin enables.
Quick measure Suggestion Admin tenant
Let’s get started-
Now go to the Home ribbon tab and click on Quick measure > Suggestions–
Quick Measure Suggestion tab
In this suggestions window you can describe the measure which you want to create and click on Generate button, see the example below-
Generate Quick Measure
And if you want to add this measure in your file, click on Add button.
Example 2-
How to get Average sales of each product-
Avg Sales Per product
Refer DAX post:- DAX Tutorials
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.