Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a forecasting plot that only returns values for the previous month and onward

Hi All,   I've created a lineplot with multiple series and one of the series is a forecasting line. For this line I'd like it to begin in the previous month only and continue for all the future for...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

Try it.

Measure = 
IF (
    EOMONTH ( MAX ( [dtForecast] ), 0 ) < EOMONTH ( TODAY (), 0 ),
    BLANK (),
    IF (
        EOMONTH ( MAX ( [dtForecast] ), 0 ) = EOMONTH ( TODAY (), 0 ),
        CALCULATE (
            SUM ( [Value] ),
            FILTER ( ALL ( tblForcast ), [dtForecast] <= EOMONTH ( TODAY (), 0 ) )),
        SUM ( [Value] )))

If not right, can you provide more information,  I can't fully understand or reproduce it.

 


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

This was your code which I implemented, which got me 90% of the way to my goal. Unfortunetly below is the result (Purple Line). 

 

The plot was perfect up until the month of JUL where it stopped being cumulative for some reason. I circumvented this by having to add an entirely new view in a SQL database which has the data already cumulative, which is unfortunate because I originally set out to do this with my current tables.