DAX to Calculate Sum from Previous Week

Hi,

Try this aproach

1. Create a Calendar Table with calculated column formulas of Year, Month name and Month number.  Sort the Month name column by the Month number
2. Create a relationship (Many to One and Single) from the Date column of your Fact table to the Date column of the Calendar Table
3. To your visua/slicer/filter, drag Date from the Calendar Table
4. Write these measures

Total = SUM('F - Actual and Projected EFTSL'[Actual EFTSL])

Total in previous week = calculate([Total],datesbetween(calendar[date],min(calendar[date])-7,min(calendar[date)))

Hope this helps.

Hi DHB ,

Based on my testing, please try the following methods:

1.Create the sample table.

2.Create the measure to calculate the previous week.

PreviousWeekEFTSL = 
CALCULATE(
    SUM('Table'[Values]),
    DATESBETWEEN('Table'[Date], MIN('Table'[Date]) - 7, MIN('Table'[Date]))
    //DATEADD('Table'[Date], -7, DAY)
)

3.Drag the date column into the slicer visual.

4.Select the date. The result is shown below.

DATESBETWEEN function (DAX) - DAX | Microsoft Learn

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.