Ever build a P&L statement in Power BI? It is not the easiest thing to build. The problem lies in the calculations. Most of the components of the P&L are calculated in different ways: some are calculations on columns of the transactions table and other are calculations on the results of the previous column calculations. You can do this in a Power BI model with a huge DAX calculation, but you can make it much simple by using Power Query to prepare the necessary data.

All you need are tables with all the ledger transactions, a calendar, and a ledger scheme. In this session we show you how to do this, by using M-Language statements.