Forum Discussion
Zidane22
Helper II
Helper IIAdd and subtract from Running total
Hello everyone, Using the foruma below I get the running total, which is great but I dont want it to keep adding to itself if there is no value (column1) to be added. I also need it to subtract ...
Try
Calculation = VAR T = ALL ( 'All Web Site Data (2)' ) VAR T1 = TOPN ( 4, T, 'All Web Site Data (2)'[TIMES], ASC ) VAR StartTime = MAXX ( T1, 'All Web Site Data (2)'[TIMES] ) VAR InService = MAXX ( T, 'All Web Site Data (2)'[EBS IN SERVICE] ) VAR Result = SUMX ( FILTER ( T, 'All Web Site Data (2)'[Date] <= MAX ( 'All Web Site Data (2)'[Date] ) ), IF ( 'All Web Site Data (2)'[TIMES] > StartTime, 'All Web Site Data (2)'[Column1] - 'All Web Site Data (2)'[Column2] ) ) RETURN InService - Result
tamerj1
Community Champion
Community Champion
VAR InService =
MAXX (
TOPN (
1,
TOPN ( 3, T, 'All Web Site Data (2)'[TIMES], ASC ),
'All Web Site Data (2)'[TIMES]
),
'All Web Site Data (2)'[EBS IN SERVICE]
)
