Copilot Formula Suggestions

Microsoft Copilot has brought several innovations in working with Excel, and one of them is the Copilot Formula Suggestions feature. This option makes it easier to create formulas by having Copilot proactively suggest next steps, recommend appropriate formulas based on data and context, and can even automatically complete the formula instead of the user. This speeds up work and reduces the possibility of errors when writing more complex formulas.

User-defined DAX functions

The DAX statement language, which we use to add new reporting dimensions to the Semantic Model, whether they are measures or calculated columns, or we use it to create tables, has a large number of functions. However, sometimes users need to create their own functions, and recently they can do it in a simple way, most often through DAX query view.