Finding row values for last 8 days based on expression that calculates the difference in days

[Coffee2023]

Hi, I need to find the pages entered Delta (new Delta Column) from the last 8 days, based on my created expression ("custom") which calculates the difference in days between my create date and today (See below screenshot column named custom). 

Here is my current measure and one line of data.

Delta = CALCULATE(SUMX('All Programs DE','All Programs DE'[Pages Entered], FILTER('All Programs DE', 'All Programs DE'[Custom], <8))

Thank you in advance for your help!

[Anonymous · Accepted solution]

Hi @Coffee2023 ,

Based on my testing, please try the following methods again:

1.Create the simple tables.

2.Create the new custom column to calculate the difference.

Custom = 
var today_ = TODAY()
RETURN
DATEDIFF('All Programs DE'[Create Date], today_, DAY)

3.Create the new measure to filter the row values.

Delta = 
CALCULATE(
    SUMX(
        'All Programs DE',
        'All Programs DE'[Pages Entered]
    ),
    FILTER(
        'All Programs DE',
        'All Programs DE'[Custom] < 8
    )
)

4.The result is shown below.

Best Regards,

Wisdom Wu

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