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.
Financial year ends april 30th | |||
last year | current year | ||
2016 | 2017 | ||
may | 900 | 100 | |
june | 200 | 200 | |
jul | 300 | 300 | |
aug | 200 | 100 | |
sep | 120 | 100 | |
oct | 200 | ||
nov | 100 | ||
dec | 100 | ||
jan | 50 | ||
feb | 200 | ||
mar | 230 | ||
apr | 150 | ||
Year to date sept | 1720 | 800 | |
change from last year | -53.5% |
The problem is calculating last year 2016 ( financail year to date value ) "1720" since the current YTD 2017 ends in september at 800.
When use the calculate function and sameperiodlastyear it adds up 12 month of last year not may - sept as needed.
Can any one help.
In short we are just trying to find our the ytd sales of the current year vs the year to date of the last year "up to the current sales month in this case is september .
Can anyone assist.
Colin
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |