Power BI: The Income Statement

For a sneak preview of this session, see Chris's YouTube video at https://youtu.be/SH4UX4fGU9A. The income statement (P&L) can be a tricky report to build within Power BI and - as such - there is much conflicting advice online about the best way to achieve this. In this session, Chris Barber will explain his preferred approach covering:

1. How to structure your data
2. How to create the data model
3. Using virtual relationships in DAX
4. Data Visualization

Chris will also show you how to create the report bridge. This allows you to easily explain variances and tell the data story about how you get from one value (budget / forecast) to the actuals.

You can download the the dataset and Power BI Desktop file shown in the session from https://bit.ly/35MRSvx