Forum Discussion
Helper IIISubtract a value from the same column
chat_peters Must not have had enough coffee yesterday. Here is the solution along with a PBIX file (attached below signature) where I include both a column and a measure solution.
Column C (Column) = VAR __Index = [Index] VAR __Minus = SUMX( FILTER( 'Table', [Index] <= __Index ), [Column B] ) VAR __Max = MAX( 'Table'[Column A] ) VAR __Result = __Max - __Minus RETURN __Result Column C (Measure) = VAR __Index = MAX([Index]) VAR __Minus = SUMX( FILTER( ALLSELECTED('Table'), [Index] <= __Index ), [Column B] ) VAR __Max = MAX( 'Table'[Column A] ) VAR __Result = __Max - __Minus RETURN __ResultHi,
If you want a calculated column formula, then this works
Column = Data[Column A]-CALCULATE(SUM(Data[Column B]),FILTER(Data,Data[Index]<=EARLIER(Data[Index])))Hope this helps.
If you want a measure, then refer to the attached file.
Super UserHi,
By any chance, do yuo have a Date column in your table? If yes, then please share the table with the date column.
Helper IIIAshish_Mathur I don't have a date table. There's really no data model. I just have this one table and I am trying to make this calculation work. I thought the index column should be good enough
- Ashish_Mathur
Hi,
If you want a calculated column formula, then this works
Column = Data[Column A]-CALCULATE(SUM(Data[Column B]),FILTER(Data,Data[Index]<=EARLIER(Data[Index])))Hope this helps.
- Ashish_Mathur
If you want a measure, then refer to the attached file.