The Power BI Masterclass - Updated
  • 1 Power BI Masterclass - beginners to advanced Introduction
  • Before you start
  • Download latest course files
  • 3 A first tour through the Power BI Interface
  • 4 Power BI the easy way - lets get started
  • Let's explore our dataset
  • 5 Power BI the easy way lets finish our first report in Power BI Desktop
  • 6 Power BI the advanced way - lets dive into our dataset
  • 7 The Power BI Query Editor - Datapreparation in action
  • 8 Import the new and advanced date table into our model
  • 9 Walk through Transformation steps in Powerquery Editor
  • 10 Data enrichment importing web data into Power BI
  • 11 Exploring the Model View and setting up Relationships
  • 12 First Calculations in Power BI Calculated Columns and Measures
  • 13 The Measures Table Trick - Structuring our report
  • 14 Power BI DAX - Practise creating further Measures
  • 15 The Beauty of Flexibility - Power BI Slicing and Dicing
  • 16 Date drill down functionalities in Power BI
  • 17 Autodatetime in Power BI - What you need to know about Date hierarchies
  • 18 Advanced Dax - Intro to Timeintelligence DAX Measures
  • 19 Advanced Dax - Flexibility in Timeintelligence DAX Functions
  • 20 Advanced Dax - Cumulative or Running Total Sales Calculation in DAX
  • 21 Power BI Lets create our final report
  • 22 Welcome to Part 2 Setting up our new model structure
  • 23 Power BI DAX - creating our base measures
  • 24 Advanced TimeIntelligence in DAX - Parallelperiod and potential use cases
  • 25 Advanced DAX - Dynamic Sales Rankings
  • 26 Advanced DAX - Running Total Sales and prior year sales
  • 27 Power BI - visualizing insights from our data
  • 28 Scenario Analysis in Power BI
  • 29 Advanced DAX - Running Total X Day Sales
  • 30 DAX - An Introduction to table functions
  • 31 Advanced DAX What are the Top 10 Clients
  • 32 Advanced DAX - How many Customers per Weekday
  • 33 Power BI DAX or no DAX - that is the question
  • 34 Advanced DAX - Customer Classification in Power BI
  • 35 Advanced DAX - Variables and Sales per Weekday and Weekends
  • 36 Create our final Report in Power BI
  • NEW - A free resource for bonus videos tips and tricks
  • Your complete Power BI Masterclass Journey
Update How to use CALCULATE in Power BI Desktop
  • About this section
  • Download latest course files for this section
  • 1 Introduction to the CALCULATE function starting from scratch
  • 2 Filter Contexts Row Context and Context Transition in Power BI explained
  • 3 Combine Calculate with ALL and VALUES
  • 4 Excourse dynamic selection with CALCULATE
  • 5 How to apply multiple criteria filter with CALCULATE in Power BI
  • 6 How to use multiple Filtercriteria with CALCULATE in Power BI OR
  • 7 CALCULATE with multiple criteria from different columns in Power BI
  • 8 Salesclassification using CALCULATE
  • 9 Cleaning up and quickly set up the new model
  • 10 Applying ALL and ALLSELECTED with CALCULATE in Power BI
  • 11 CALCULATe with the Keepfilters modifier
  • 12 Modify model relationships with CALCULATE
  • 13 Using Context Transition with CALCULATE to evaluate the maximum sales on a da
  • 14 Visual understanding of the expanded table concept
  • 15 CALCULATE modifiers remove all filters except one
  • 16 Using CALCULATE with Timeintelligence Expressions
additional resources - (with older interface but still valid)
  • Resources
  • 22 How to improve our reports using custom visuals
  • 38 How to publish your report to the Power BI Service
  • Bonus How to create Datestables in DAX
  • Bonus - SUMX vs SUM in Power BI Whats the difference and when to use which examp
  • Best and worst Customers and Products , Products with Sales between
  • How to create your own BUMP chart in Power BI
  • Bonus - All about customizing and dynamic buttons in Power BI