Similar Posts
Removing Unnecessary Rows in Power Query
One of the most common data cleansing operations performed in Power Query is the removal of unwanted rows. And this is a topic which we cover in almost all of our Power BI training courses. In this blog post, we will look at the key M function used to suppress unwanted rows. Table.Skip The first…
Power BI MCSA Certification Training Tips – Part 12: Power Query Custom Functions
To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap between the two exams resulting from the common BI features found in both Power BI and Excel: namely data modelling using…
Power BI MCSA Certification Tips – Part 1 : M Language Overview
To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap between the two exams resulting from the common BI features found in both Power BI and Excel: namely data modelling using…
Power BI MCSA Certification Training Tips – Part 9: Split into Rows vs Columns
To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap between the two exams resulting from the common BI features found in both Power BI and Excel: namely data modelling using…
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…
Free Power BI Books
Power BI enables business users to interact with corporate information and to extract the reports and intel they need. Power BI allows users to access reports and dashboards using familiar tools and devices. Self-service BI has never been so user-friendly! If you are looking to learn Power BI, then our series of Power BI…
