Microsoft Copilot is a chatbot, based on ChatGPT, and is integrated within many Microsoft services and applications. If you use it in Power BI Desktop reporting platform, it enables you to create quick measures and to generate DAX statements based on natural language. With Microsoft Copilot, creating measures has become much simpler, and you will find out how it is used in the “recipe” that follows.
You have probably noticed that in Power BI service Datasets have recently been replaced by Semantic Models. Model Explorer is a new feature of Power BI Desktop. It is located in the Model view, and enables views and work with complex semantic models that contain tables, relations, measures, roles, calculation groups, cultures, perspectives…
In the Home ribbon there are options for adding measures (New Measure) and calculated columns (New Column), and recent novelty is functionality that is used to add „quick measures“ (New Quick Measure). It allows beginners that do not have the experience of writing a DAX expressions to create measures by simply dragging names of the reporting dimensions into the predicted fields, after which application automatically generates formulas.
When you write DAX expressions it is a general recommendation not to overestimate their complexity. It is always better to create several measures and further consolidate them within the new formula. The code is more transparent, and there is a lot less chance to make an error. Since recently DAX also allows making variables. They are used to create measures that will be used to create an expression that returns final result.