Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I'm really stumped on creating a DAX measure for this calculate, it appears to be really simply but I'm really struggling. I need to calculate rolling/accumaltive sales over a financial year which starts Sept -Aug. I do not want to include the sales from any other previous years.
Here's an example of the data from excel and it's the Rolling FY year total I need to calculate. In my report I have a FY slicer so I will need to be able for flip between financial years. I do help someone can help. Kind regards Jo
MONTH | Sales By Month | Rolling FY Yearly Total |
Sep-16 | £1,450,156.00 | £ 1,450,156.00 |
Oct-16 | £874,019.00 | £2,324,175.00 |
Nov-16 | £1,063,685.00 | £3,387,860.00 |
Dec-16 | £774,785.00 | £4,162,645.00 |
Jan-17 | £856,423.00 | £5,019,068.00 |
Feb-17 | £792,407.00 | £5,811,475.00 |
Mar-17 | £979,384.00 | £6,790,859.00 |
Apr-17 | £763,471.00 | £7,554,330.00 |
May-17 | £833,589.00 | £8,387,919.00 |
Jun-17 | £765,367.00 | £9,153,286.00 |
Jul-17 | £881,125.00 | £10,034,411.00 |
Aug-17 | £856,355.00 | £10,890,766.00 |
Solved! Go to Solution.
Hey,
almost everything that is related to time can be found here
daxpatterns.com/time-patterns
Hopefully this gets you started
Regards
Tom
Hey,
almost everything that is related to time can be found here
daxpatterns.com/time-patterns
Hopefully this gets you started
Regards
Tom
thank you @Anonymous this link is extremely useful
😉 indeed it is
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |