Forum Discussion

ryan_b_fiting's avatar
ryan_b_fiting
Icon for Post Patron rankPost Patron
4 years ago
Solved

Calculation Item - Rolling 7 Day Total

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

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • SergioSilvaPT's avatar
    SergioSilvaPT
    4 years ago

    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.

2 Replies

  • SergioSilvaPT's avatar
    SergioSilvaPT
    Icon for Resolver V rankResolver V
    4 years ago

    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.