topic CALCULATE SUM for specific range in DAX Commands and Tips

CALCULATE SUM for specific range

joshua1990 — Wed, 26 Jan 2022 18:45:56 GMT

Hi experts!

I have a calendar, a dimensional and a transactional table.

Then I have a matrix that is filtered for the current week.

This matrix shows me the sales for the current week.

In addition, I would like to get the sales (table transactional) that happened between the last Saturday and today.

How is this possible by using DAX?

CALCULATE with REMOVEFILTERS?

Re: CALCULATE SUM for specific range

Greg_Deckler — Wed, 26 Jan 2022 19:02:00 GMT

joshua1990 Correct, you could use REMOVEFILTERS or ALL/ALLEXCEPT in order to override filter context within the measure. Sample data would allow more specificity.

Re: CALCULATE SUM for specific range

joshua1990 — Wed, 26 Jan 2022 19:57:11 GMT

Greg_Deckler : Thanks a lot! How can the range be specified in the function? Any logic that you can share here?

Re: CALCULATE SUM for specific range

Greg_Deckler — Wed, 26 Jan 2022 23:20:30 GMT

joshua1990 Well, you could find the last Saturday by doing something like this:

Measure = VAR __Calendar = ADDCOLUMNS(CALENDAR(TODAY()-7,TODAY()),"__Weekday",WEEKDAY([Date],2)) VAR __LastSaturday = MINX(FILTER(__Calendar,[__Weekday]=6),[Date]) RETURN CALCULATE([someting],ALL('Dates'),'Dates'[Date]>=__LastSaturday,'Dates'[Date]<=TODAY())