Forum Discussion
ahorne27
8 years agoNew Member
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...
- 8 years ago
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 ) )
ahorne27
8 years agoNew Member
Thanks everyone for such quick replies! In the end the measure worked best with my content.