Automatic saving of Excel documents has been around for a very long time. If you go to Excel Options, in the Save section, you will see the option to Save Autorecover Information Every… and the number of minutes after which the saving is performed. However, this works if your computer resets or for some other reason stops working. With the advent of the OneDrive repository and storing documents on it, we got a new, better Autosave…
Although Excel recognizes only two types of data: numbers and text, sometimes you’ll be working with Boolean values, such as TRUE and FALSE expressions. There is a simple trick to convert these values into ones and zeros respectively, so that you can add them more easily, and you will find out how to do this in a short “recipe” that follows.
More recently, Microsoft Copilot, an AI-based assistant, has become an integral part of Excel in all its versions. Now it can help you, in English or another language, analyze data, create charts, offer you the appropriate Excel function, or show you its syntax. To put a long story short, it can make your daily work much more productive!
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.
While most data analysts are still developing reports in Power BI Desktop, more and more want to use the Power BI service for this purpose. Maybe it’s because they’re using a Mac computer, a Linux operating system, or for some other reason. That is why the Microsoft development team made it possible for users to access the Data Model directly from the web browser, i.e. now you can use Model View at the same way as in Power BI Desktop.