Make data blank after specific date (preferable after "today")

[Anonymous]

Hi all,

This is my first post, so if you have any general remarks on the way I ask for help, please let me know. 

on topic:

I am using the LINESTX function to predict values based on historucal data. In this case I want to predict the number of sales. In the picture below you can see that the data line (dark blue) is running after today and I think this will influence my results. So my question is how can I remove these values (0) into blanks?

The measure I created up to now is:

Sumparts =

VAR SUMPARTS1 =

    sum(Sales_per_Customer_per_Date[Invoiced_Quantity])

    return

    if(isblank(SUMPARTS1),0,SUMPARTS1)

So I think I have to add something to this measure. This measure I use finally in the linestx:

Simple linear regression =

VAR Known =

    FILTER (

        SELECTCOLUMNS (

            ALLSELECTED ( CaseCreatedDate[Date] ),

            "Known[X]", CaseCreatedDate[Date],

            "Known[Y]", [Sumparts]

        ),

        AND (

            NOT ( ISBLANK ( Known[X] ) ),

            NOT ( ISBLANK ( Known[Y] ) )

        )

    )

VAR SlopeIntercept =

    LINESTX(Known, Known[Y], Known[X])

VAR Slope =

    SELECTCOLUMNS(SlopeIntercept, [Slope1])

VAR Intercept =

    SELECTCOLUMNS(SlopeIntercept, [Intercept])

RETURN

    SUMX (

        DISTINCT ( CaseCreatedDate[Date] ),

        Intercept + Slope * CaseCreatedDate[Date])

Many thanks in advance! 

[johnt75 · Accepted solution]

Try

Sumparts =
VAR MaxDate =
    MAX ( 'CaseCreatedDate'[Date] )
RETURN
    IF (
        MaxDate <= TODAY (),
        VAR SUMPARTS1 =
            SUM ( Sales_per_Customer_per_Date[Invoiced_Quantity] )
        RETURN
            IF ( ISBLANK ( SUMPARTS1 ), 0, SUMPARTS1 )
    )

[Anonymous]

Thank you very much, looks like it works fine!