topic Re: Analyze - Explain Increase now missing in DAX Commands and Tips

Analyze - Explain Increase now missing

Ade108 — Fri, 06 Jan 2023 11:16:49 GMT

Hi all,

I've been using the 'analyze - explain the increase' frequently in my new dashbaord and it's one of my most useful features. Rather worryingly though I've noticed it's now not available and I can only see 'find where distribution is different'.

The only change I have made recently is I've updated the X-axis with dates from a new calendar table as mentioned in my last post here.

Solved: Parallelperiod -1 showing values from -3 months ag... - Microsoft Power BI Community

Can anyone please help why this is missing? I've read the exclusions on when this function won't work but I'm still unsure why I could use it before I updated the X axis.

Thanks

Re: Analyze - Explain Increase now missing

tmack99 — Sat, 07 Jan 2023 08:00:55 GMT

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.

Re: Analyze - Explain Increase now missing

Ade108 — Tue, 10 Jan 2023 12:49:02 GMT

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!)

Re: Analyze - Explain Increase now missing

tmack99 — Wed, 11 Jan 2023 07:58:26 GMT

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

Re: Analyze - Explain Increase now missing

Ade108 — Thu, 12 Jan 2023 08:48:58 GMT

Thank you tmack99 , will take a deeper look based on your advice