Financial Years

StewartS

Board Regular
Joined
Feb 24, 2002
Messages
217
Hi I'm new to powerpivot and just trying to get to grips with a few things. I need to create some totals for full year actuals for last Financial Year and year to date actuals for last Financial year and the current finacial year. The problem I'm having is that the year runs from April to March and I can't see how to do this in Dax functions. I assume I need to combine some but I'm not sure where to start.

Thanks

StewartS
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
An addition to this post if I use see results

Row Labels Sum of Total Value YTD Sales Prior Year Sales
30/04/2011 435567.69 435567.69 435567.69
31/05/2011 491434.49 927002.18 927002.18
30/06/2011 494364.69 1421366.87 1421366.87
31/07/2011 447719.91 1869086.78 1869086.78
31/08/2011 493274.07 2362360.85 2362360.85
30/09/2011 508731.83 2871092.68 2871092.68
31/10/2011 567774.85 3438867.53 3438867.53
30/11/2011 559377.61 3998245.14 3998245.14
31/12/2011 454499.23 4452744.37 454499.23
31/01/2012 479319.29 4932063.66 933818.52
29/02/2012 557052.96 5489116.62 1490871.48
31/03/2012 585345.76 585345.76 2076217.24
30/04/2012 416236.84 1001582.6 2492454.08
31/05/2012 482242.1 1483824.7 2974696.18
 
Upvote 0
I've solved this issue - getting confused between that way dates are written in UK and USA - in the words of Homer Simpson Dohhh!
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,148
Members
448,552
Latest member
WORKINGWITHNOLEADER

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