A lot of finance teams want to move their profit and loss statement out of Excel and into Power BI, but building an automated P&L from chart of accounts data can get tricky very quickly. In this video, I show you how to build a fully automated income statement in Power BI from raw journal entry/chart of accounts data. We start from the raw data, create a simple P&L template, map account IDs to the right income statement lines, build the model, and then use a very simple DAX approach with TREATAS to make the whole thing work. If you’ve been wondering how to create a P&L in Power BI, an income statement in Power BI, or automate financial reporting from GL / chart of accounts data, this video will help.
How to Create an Automated P&L in Power BI
