Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

CALCULATE SUM for specific range

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 additio...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    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())
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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