Forum Discussion
Conditional sum based on next row
Hi, I have a requirement to calculate the total for the current row based on the next rows using DAX : Data Set : Type Value Rule Expected Result A 10 B + C +D +E 250 B 20 C + ...
Anonymous , change like
new column = if( table[index] < max(table[Index]), sumx(filter(Table, [index] > earlier([index]) ) , [Value]) ,table[Index])
Sorry, I did not notice that
Anonymous , change like
new column = if( table[index] < max(table[Index]), sumx(filter(Table, [index] > earlier([index]) ) , [Value]) ,table[Index])
Sorry, I did not notice that
yep its wokring fine , thanks alot .