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
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

StewartS

Board Regular
Joined
Feb 24, 2002
Messages
217
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
 

StewartS

Board Regular
Joined
Feb 24, 2002
Messages
217
I've solved this issue - getting confused between that way dates are written in UK and USA - in the words of Homer Simpson Dohhh!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,569
Messages
5,596,915
Members
414,110
Latest member
docops

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
Top