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?
Calculated Items allow you to create formulas based on arithmetic operations between elements in rows and/or columns within a pivot table. Sometimes Excel can get confused and display incorrect results due to a misinterpretation of the order of computational operations. Solve order is an option with which we can change the order to get the correct result.
Exporting a table to PDF is not a new feature, it has been around for ten years or more. But how to import a table from a PDF document into Excel? This task is performed by Power Query which, since the latest version, has become an integral part of Excel and you can’t bypass it, no matter what kind of data you import into the application. Since recently he has this fantastic option, let’s see how it is used …