How to count words? There is no longer a need to send telegrams, and the need to count words seldom arises. However, this is a nice opportunity to try out how to use the TEXTSPLIT function in combination with some other Excel functions. Who knows, maybe this will be useful to you one day? In honor of Pink Floyd, let’s count the words in the song “Shine On You Crazy Diamond”.
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.
Arranging data sets in Excel reports can sometimes get complicated, for example when you are editing a list of visitors to your stand at a business fair or congress. Then we usually manually copy the lists, merge them, and further remove duplicates. Excel has some new functions that allow you to literally do this procedure in a couple of steps, and in the following “recipe” you will find out how to apply them in practice.
For several years now, Power BI and Excel have been developing side by side with the idea that analysts do not save all their tables exclusively on a local computer, OneDrive or SharePoint repositories, but that they can also download them from Power BI reports that are published on the company’s tenant. If you use a Microsoft365 subscription that is connected to a company account, you can easily retrieve such tables.
If you want to present a report based on data, you will do so by connecting to the source, purifying, modeling it and then adding appropriate visualizations. As part of the modeling process, we often created measures and calculated columns by writing DAX statements. In a similar way, we were able to add Quick Measures. Now there is an even easier way, and that is to create calculations within a visual…