I’m working on the topic of Budgeting and Forecasting and trying to work out a Sales seasonality per month. I am using the dataset provided on the site for the course (Mini serie).
I have the following Sales table:
The following Dates table:
And the following Products table:
The data model is as stated in the course, as follows:
I have set up the Toal sales measure as follows:
Now, what I want is to have the total Sales value for each year, for all rows of the same year. For example, the total for 2015 is 59’394’341 and I want that value for all the rows for the year 2015. that would enable me to calculate January 2015 seasonality, i.e. 6’071’955 / 59’394’341 = 10.2%.
I have then set up the following measure, expecting it would work, but it doesn’t:
The ALL function with the Dates table doesn’t seem to be working.
I don’t understand why because if I do the same for the products (not to calculate seasonality, but just as an example), I get the right totals:
the ALL function works with the Products table.
I am missing something fundamental I believe but cannot get what. Thank you for your help.