How to omit empty values from PredictTimeSeries DMX query

Question

I'm using the PredictTimeSeries function within the DMX query in order to get some values predictions, as follows:

select flattened
 PredictTimeSeries([MiningModel_8].[Values], 100)
from 
[MiningModel_8]

It works well, the only problem is that at some point, the result set returns empty values, like so:

Expression.$TIME    Expression.Values
-------------------------------------
30/04/2015          6
01/05/2015          4
02/05/2015          4
03/05/2015          3
04/05/2015          3
05/05/2015          <<-- here it becomes empty
06/05/2015 
07/05/2015 

How can I cut the empty rest of the result set (so the last record in the above example would be from 04/05/2015)?

Any advice or help is appreciated, thank you

Answer 1

I believe you can limit the result set by using WHERE clause. More details: https://msdn.microsoft.com/en-us/library/ms132048.aspx