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 ChampionTry
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
Zidane22Helper II
Helper IIHello tamerj1 !
Sorry to bother you again,
If I were to use the value in the second row or thrid row etcc.. how can i modify ths part :
VAR InService = MAXX ( T, 'All Web Site Data (2)'[EBS IN SERVICE] ) VAR Result = SUMX (
Thanks again!
- Zidane22
All good now thank you again.