DAX ALL Function
DAX ALL Function
New Power BI Currency Conversion Solution
A new Power BI solution has been added to our library. In this solution, we use parameter tables to allow the user to control key aspects of a currency conversion dashboard. The dashboard allows the user to track the conversion rate from any one currency to another in a basket of 15 currencies, and to…
New Power BI Sales Pipeline Solution
A new Power BI solution has been added to our library. Since this solution deals with a sales pipeline, it contains a main fact table which contains multiple significant dates as we track the progress of each lead from the contact stage right through to sales. This means that we need to use Power BI’s…
New Power BI Sales Report Solution
A new Power BI solution has been added to the members resources library. This solution contains a number of features which may be useful to both new and experienced Power BI report developers. Subscribers to our Power BI Comprehensive Introduction course receive step-by-step practice in building this sales report from the ground up. A Report…
Power BI DA-100 Exam Tips
Manage datasets
Providing access to datasets
In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In this Power BI training post, we will examine DA-100 exam – Manage datasets: Providing access to datasets….
Easily Change All Data Sources from Excel to SQL Server
This blog post will show you how to Easily Change All Data Sources from Excel to SQL Server in a given solution. The idea of using power query parameters to rapidly change which data sources your tables are coming from, has been around for a long time. What we are going to do in this…
Connecting to Web Data (Get Data – Web)
Connecting to Web Data (Get Data – Web) When connecting to web data (Get Data – Web), connecting to a web URL does not imply any specific format. The file being accessed via the web may be in any format: CSV, XML, JSON etc. However, be aware that accessing web data using its native connector…
Replicating Qlik Sense Keep Operations in Power Query
Replicating Qlik Sense Keep Operations in Power Query turns out to be fairly straightforward. I was recently asked by a client whether the Keep operations present in Qlik Sense could be replicated in Power Query. The Keep functionality allows report developers to import two tables which each observe a join but where the two tables…
Connecting to SharePoint Folders
Connecting to SharePoint Folders is similar to connecting to folders on your file system. The Get Data > Folder connector allows you to connect to a folder containing files of the same type and combine the data they contain into a single query. You simply specify the folder you want to connect to and all…
Nesting SELECTEDVALUE in Power BI Dynamic Titles
In Power BI, you can create dynamic titles for any visuals, by creating DAX measures which track the current state of the fields displayed within the visual itself or other related slicers and visuals. These dynamic titles can be used to convey useful feedback to report consumers as they interact with your reports. The main…