Forum Discussion

tmacfrank's avatar
tmacfrank
Frequent Visitor
8 years ago
Solved

Accumulate values in a column

Hi,   I am trying to accumulate NBIT values in a column like this.         Accu_NBIT = CALCULATE( SUM('Total Distribution All'[NIBT]), FILTER( ALL('Total Distribution All'[NIBT]), 'T...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi tmacfrank,

     

    Add an Index Column to your table in Query Editor, and then try with this DAX formula to create your column

     

    Accu_NBIT =
CALCULATE (
    SUM ( 'Total Distribution All'[NIBT] ),
    ALL (Total Distribution All),
    'Total Distribution All'[Index]
        <= EARLIER ( 'Total Distribution All'[Index] )
)

    Regards

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi tmacfrank,

 

Add an Index Column to your table in Query Editor, and then try with this DAX formula to create your column

 

Accu_NBIT =
CALCULATE (
    SUM ( 'Total Distribution All'[NIBT] ),
    ALL (Total Distribution All),
    'Total Distribution All'[Index]
        <= EARLIER ( 'Total Distribution All'[Index] )
)

Regards