Forum Discussion

ahorne27's avatar
ahorne27
New Member
9 years ago
Solved

Accumulative values from a count

Hi All   I am struggling to plot data that accumulates the values from a count.   To illustrate what I am trying to do I have created the table in Excel   Item Name Cost Per Item x Number S...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    ahorne27,

     

    You may also refer to the following DAX that creates a measure.

    Measure =
VAR n =
    MAX ( Table1[Item Name] )
VAR t =
    MAX ( Table1[Timestamp] )
RETURN
    CALCULATE (
        SUM ( Table1[Cost Per Item x Number Sold] ),
        FILTER (
            ALLSELECTED ( Table1 ),
            Table1[Item Name] = n
                && Table1[Timestamp] <= t
        )
    )
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
9 years ago

Hi ahorne27,

 

You may also try this calculated column formula

 

=CALCULATE(SUM(Table1[Cost Per Item x Number Sold]),FILTER(Table1,Table1[Item Name] = EARLIER(Table1[Item Name])&&Table1[Timestamp]<=EARLIER(Table1[Timestamp])))

Hope this helps.