Columns and Totals Do Not Match

Hi,

Try this.

1. Create a Calendar Table with calculated column formulas for Year, Month name and Month number.  Sort the Month name by the Month number
2. Create a relationship (Many to One and Single) from the Date column of the invoice table to the Date column of the Calendar Table
3. To any visual, filter, slicer, drag any Date dimension only from the Calnedar Table
4. Write these measures

Sales Last 4 Weeks = CALCULATE( SUM( 'Invoice Data'[Amount] ), datesbetween( 'calendar'[date],min('calendar'[date])-28,min('calendar'[date])))

This measure will give you the wrong result in the Total row.  Therefore, drag this measure below to the vissual

Measure = SUMX(VALUES('Calendar'[Date]),[Sales last 4 weeks])

If these measures do not work, then share the download link of the PBI file.  Show the problem there and the expected result.

Thanks for the reply from Ashish_Mathur , please allow me to provide another insight:

 

Hi PizzaJim ,

 

Try to modify your formula like below:

 

Sales Last 4 Weeks = 
VAR __MaxDate = MAX('Invoice Data'[Date])
VAR __StartDate = __MaxDate - 28
RETURN
    CALCULATE(
        SUM('Invoice Data'[Amount]),
        FILTER(
            ALL('Invoice Data'),
            'Invoice Data'[Date] <= __MaxDate &&
            'Invoice Data'[Date] > __StartDate
        )
    )

 

 

Best Regards,
Adamk Kong

 

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