Building Financial Income Statement

[marsclone]

https://powerpivotpro.com/2018/01/star-schema-switch-drill-income-statement-design/

With the help of this blogpost, i was able to produce a P&L that works for me. I think that a lot of people can use this blogpost for building financial income statements. I’m no expert and i managed to get there.

Now i can build with the help of different matrix’s a P&L for a:

Month (actual vs budget)

Ytd last year (actual)

Ytd this year (actual vs budget)

This year (budget)

Last year (Actual)

My question is, is it possible to get these values in one matrix? With a month/year slicer?

I’ve added a testfile. Thank you in advance!

Test

[tylesftw]

Hey, thanks for this tutorial. You link does not work anymore?