When we use the DAX function CALCULATE and give it the filter values as arguments as a result we will get a Power Pivot report filled with rows containing the same values. Although these values correspond to the given filter this way of displaying data is not the best solution. To make report neat, we can use the FILTER function or, even better, the KEEPFILTERS function about which you will learn more if you read the text that follows …
The CONCATENATE function is used to join strings in the DAX language. DAX also has a corresponding “X” function that acts as an iterator and allows joining of multiple strings with an option to use delimiter and sorting direction by given expression. In this post, you will learn how to use the CONCATENATEX function in a specific example, by displaying all brands in relation to the filter of the manufacturer to which they belong.
From the very beginning, Power BI allows us to import Excel workbooks in two ways: as a data source or as a report. This second option is useful when we already have ready-made reports that we want to use in parallel with Power BI reports. Recently, within the Microsoft 365 subscription, the Publish to Power BI option has appeared, which enables direct publishing of reports on the Power BI service. How does this work?
Microsoft Teams allows you to easily access additional applications from the main menu – cloud services and connectors that you will use in your daily work. There are a handful of useful applications, organized by categories, which improve the functionality of Teams such as: Forms, Shifts, Approvals, Stream, Power BI, One Note and many others …
Microsoft Teams offers the ability to talk to two or more users via chat or within the channels of one of the teams. This is quite reminiscent of traditional chat, but there are a few differences, so it seems appropriate to set aside a special post for this topic. In this text, you will learn about several additional possibilities of cooperation within the channel, as well as how to add an application/service that will be used by all its members …