Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incremental Subtraction

It is quite simple in excel but not able calculate in the power bi,
backlog is 2061 at the starting point output will be 2061-163=1898 then it goes to 1898-140=1758 then 1758-180=1578 then 1578-50=1528

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    First create an index column

     

    Then create the following calculated column

    Work Remaining =
CALCULATE ( SUM ( 'Table'[backlog] ), FILTER ( 'Table', [Index] = 1 ) )
    - CALCULATE (
        SUM ( 'Table'[Acutal work finished] ),
        FILTER ( 'Table', [Index] <= EARLIER ( 'Table'[Index] ) )
    )

     

    Check more details from the attachment.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    First create an index column

     

    Then create the following calculated column

    Work Remaining =
CALCULATE ( SUM ( 'Table'[backlog] ), FILTER ( 'Table', [Index] = 1 ) )
    - CALCULATE (
        SUM ( 'Table'[Acutal work finished] ),
        FILTER ( 'Table', [Index] <= EARLIER ( 'Table'[Index] ) )
    )

     

    Check more details from the attachment.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.