Forum Discussion
Analyze - Explain Increase now missing
Your previous use of the increase function was probably a result of the fact that your X-axis contained a certain set of dates. My guess is the increment functionality ceased to function when you updated the X-axis with new dates from a new calendar table because it was unable to recognize the new dates. Make sure the new dates are formatted appropriately and that they fall inside the same date range as the original X-axis in order to resolve this problem. To make sure that the increase feature is correctly recognizing the new dates, you might also need to change its parameters.
this feature is only available when the following conditions are met:
The data is a time series.
The data is continuous (not discrete).
The data is numerical.
Thanks for your response tmack99
The only major difference I can think of is that I changed the source of my default 'date' column. I was using an excel table (with a one column of dates) but have since moved to =calendar dax as shown below.
The X axis then uses the 'MMM YY' column however it did before when it worked so I'm struggling to understand what has changed (sorry, I'm still a novice!)
The CALENDARDAX function automatically creates a date column based on the specified range. This means that the column will update itself as you add more data to your model. It is unlikely that the 'MMM YY' column is causing the issue, because this feature uses statistical analysis of variables, not the format of the X-axis.
Another possibility is that some of your data is missing, which could be why the statistical analysis isn't working. Make sure all your data is there and there are no blank spaces or null values for the field you're using on X-axis. Also, check that the X-axis isn't generating any errors.
It's hard to say exactly what's causing the problem without more information about your data and what specific steps you took when implementing
