PowerBI Pro Forma Financials: Modelling Beyond Excel | Part 1

Download the templates (free): pages.ptarmy.com/download Excel has always been the standard for pro forma financials and modelling, but PowerBI will overtake it in the near future. Watch this tutorial to level up your modelling skills, and give your customers the flexibility enabled by a web based income statement with sensitivity sliders. This is part one, next up is the balance sheet and cash flow statement. 🚀Who Should Watch This ChatGPT/Power BI Tutorial? Beginners interested in how to model an income statement Finance professionals who are excel masters, but curious about PowerBI Data enthusiasts interested in new ways to work with data 🎯Timestamps: [00:00] Opening [01:20] Excel vs PowerBI Modelling [02:23] 3 Reasons PowerBI is better [03:37] Basic Data Inputs [07:30] Concepts of PATH and hiearchy [10:51] Custom Sorting [12:17] Magic Income Statement Measure [16:27] Pro Forma Forecast [17:37] User Parameters for Sensitivities [18:57] Measure #2 - adding forecast