Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

Running Total without calculate?

Hello, is there a way to compute running total without the calculate function? For example via creating a table variable inside a measure and sum it up via sumx? With this sample data:   Date ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Applicable88 Yes:

    Measure =
  VAR __Date = MAX('Table'[Date])
RETURN
  SUMX(FILTER(ALL('Table',[Date] <= __Date),[Sales])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Applicable88 Yes:

Measure =
  VAR __Date = MAX('Table'[Date])
RETURN
  SUMX(FILTER(ALL('Table',[Date] <= __Date),[Sales])
  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    4 years ago

    No doubt, it's your most favooooooooorite way to kick off CALCULATE. ðŸ¤£

  • pstaggers's avatar
    pstaggers
    Icon for Advocate II rankAdvocate II
    4 years ago

    Just me, or is there a missing paren in this?

     

    Measure =
    VAR __Date = MAX('Table'[Date])
    RETURN
    SUMX(FILTER(ALL('Table',[Date] <= __Date),[Sales])