Calculation Item - Rolling 7 Day Total

[ryan_b_fiting]

Hello Community - 

I am having an issue creating a Calculation Item in the Tabular Editor for a Rolling 7 Day Total.  When I put my DAX measure below in tabular editor I get an error: "Expression - The end of the input was reached"

Below is my measure (very simple) that I am using, and I am not sure where this is going wrong?  Any insight to this would be GREATLY appreciated.

CALCULATE( 
    SELECTEDMEASURE(),                                 
    DATESINPERIOD(Date_Table[Date],            
        LASTDATE(Date_Table[Date]),-7,DAY )

Thank you!

Ryan F

[SergioSilvaPT · Accepted solution]

Hi @ryan_b_fiting ,

You're missing a parenthesis in the end?

CALCULATE( 
    SELECTEDMEASURE(),                               
    DATESINPERIOD(Date_Table[Date],           
        LASTDATE(Date_Table[Date],-7,DAY )
        )

Regards,

Sérgio Silva 

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

[ryan_b_fiting]

@SergioSilvaPT wow, I guess I should have focused a little better!  Thanks for the extra eyes on my measure!