How to get the total views 7 days ago

[nleuck_101]

Hello All,

I'm having issues for some reason coming up with a simple measure. I have a date field and I created a measure that calculates the Total Views ( SUM(Table('Views')). I would like to create a measure that get me the Total Views 7 days ago. I would like to get the Total Views on 1/8/2025 (3,737) but I'm getting over 60K. My max date is always the previous day. Any help would be greatly appreciated.

[Bibiano_Geraldo]

Hi @nleuck_101 ,

You can achieve your goal by this DAX:

Last7Days = 
CALCULATE(
    SUM('Table'[Views]),
    FILTER(
        'Table',
        'Table'[Date] = MAX('Table'[Date]) - 7
    )
)

[Anonymous · Accepted solution]

Hi @nleuck_101 

Please try the following measure:

Last7DayViews = 
CALCULATE(
    SUM('Table'[Views]),
    FILTER(
        'Table',
        'Table'[Date] = MAX('Table'[Date]) - 7
    )
)

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.