Week comparison

Hi~ Anonymous 

Please create a new column.

Column = 
IF (
    'Table'[Value]
        < CALCULATE (
            SUM ( 'Table'[Value] ),
            'Table'[Week]
                = EARLIER ( 'Table'[Week] ) - 1,
            ALLEXCEPT ( 'Table', 'Table'[Module], 'Table'[Output] )
        ),
    'Table'[Value]
)

The result should be like this.

I hope I understand correctly, if not then please let me know.

Best Regards,

Community Support Team _ Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!