Change negative result to 0

[AllanBerces]

Hi good day, 

Can anyone help me on my calculated column, if the result is negative change to 0.

Daily Earned =

CALCULATE (

    SUM ( 'JC Daily Progress'[Daily Earned] ),

    FILTER (

        ALL ( 'JC Daily Progress' ),

        'JC Daily Progress'[Progress Date] = EARLIER ( 'S-CURVE_OVERALL'[Plan Date] )

            && 'JC Daily Progress'[Projectname] = EARLIER ( 'S-CURVE_OVERALL'[ProjectName] )

    )

)

Thank you

[DataNinja777]

Hi @AllanBerces ,

What about modifying your calculated column dax like below:

Daily Earned =
VAR Result =
    CALCULATE (
        SUM ( 'JC Daily Progress'[Daily Earned] ),
        FILTER (
            ALL ( 'JC Daily Progress' ),
            'JC Daily Progress'[Progress Date] = EARLIER ( 'S-CURVE_OVERALL'[Plan Date] )
                && 'JC Daily Progress'[Projectname] = EARLIER ( 'S-CURVE_OVERALL'[ProjectName] )
        )
    )
RETURN
    IF ( Result < 0, 0, Result )

Best regards,

[AllanBerces]

Hi @DataNinja777 thank you for the reply, but showing some error.

Thank you

[DataNinja777 · Accepted solution]

Hi @AllanBerces ,

Apologies for the typo.  What about like below?

Daily Earned =
VAR Result =
    CALCULATE (
        SUM ( 'JC Daily Progress'[Daily Earned] ),
        FILTER (
            ALL ( 'JC Daily Progress' ),
            'JC Daily Progress'[Progress Date] = EARLIER ( 'S-CURVE_OVERALL'[Plan Date] )
                && 'JC Daily Progress'[Projectname] = EARLIER ( 'S-CURVE_OVERALL'[ProjectName] )
        )
    )
RETURN
    IF ( Result < 0, 0, Result )

 Best regards,

[AllanBerces]

@DataNinja777 thank you all good.