PowerPivot Income Statement MTD & YTD

anteus

New Member
Joined
Jun 29, 2017
Messages
9
Hello Power BI forum!
I am trying to develop a PowerPivot based Income Statement report (my previous version is a Power Query table with SUMIFS but that has become extremely slow with 20k records of data - this is mistery to me too) and I cannot figure out how to filter YTD periods with slicer. Let me show the desired structure below:

Month Actuals / Month Budget / Month LastYear / YTD Actuals / YTD Budget / YTD LastYear
Revenues
Direct costs
...
...
...

Since the structure is fixed I would go with Cube formulas on the data model but don't know how to deal with YTD with the aim to be able to select any period in the past. The data records contain period, amount, account mapping info, etc.
Any help, hint, idea is appreciated.
Best regards, Laszlo
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Thanks, it looks great in Excel online. I don't see however the mechanics behind the curtain. While fully understand ip protection concerns could you share some info on the measures used?
Thanks and best regards

Sorry about that. Had intended for you to be able to download a copy. Try this one:

Sample Financial Again
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top