Infographic: Power BI – Unpivot Columns

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…

In spite of its bland name, the CALCULATE function is the most important function in the DAX language and by far the most widely used in advanced DAX calculations. The power of the CALCULATE function stems from the fact that it allows you to change the context in which a DAX calculation takes place. One…

Power BI Essentials Quiz 1… Are you an aspiring Power BI power user? Do you know the essentials of Power BI? Thinking of taking the exam 70-778? If you answered yes to all three questions, then you should ace our Power BI Essentials Quizzes; right? Are you ready for Quiz Number One? Click below to…

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…

Part 1 (of 4): the Power BI Product Click here to download the tutorial work files Power BI online training Microsoft Power BI consists of three parts Power BI Desktop, the Power BI service and Power BI mobile apps. Power BI Desktop is the workhorse of the three: this is where you connect with your…

Part 4 (of 4): Creating a Report in Power BI Desktop 2 Click here to download the tutorial work files Power BI online training In the previous tutorial in this series, we discussed the use of the synoptic panel custom visual to build a car damage report; and we examined the completed report. In this…