Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Removed Zero from Previous Date

Hi Good day, 

I have a calculated column, can anyone help me on how can i removed the zero from previous date and leave it blank.

 

 

cumul forecasted =
var cumul_foreacsted =
SUMX(
    FILTER(
        'S-CURVE_OVERALL',
        'S-CURVE_OVERALL'[Plan Date] <=EARLIER('S-CURVE_OVERALL'[Plan Date])
    ),
    'S-CURVE_OVERALL'[forecasted]
)


return cumul_foreacsted
 
Thank you
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    AllanBerces , You can use blank function for this

    cumul_forecasted =
    VAR cumul_forecasted =
    SUMX(
    FILTER(
    'S-CURVE_OVERALL',
    'S-CURVE_OVERALL'[Plan Date] <= EARLIER('S-CURVE_OVERALL'[Plan Date])
    ),
    'S-CURVE_OVERALL'[forecasted]
    )
    RETURN
    IF(cumul_forecasted = 0, BLANK(), cumul_forecasted)

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    AllanBerces , You can use blank function for this

    cumul_forecasted =
    VAR cumul_forecasted =
    SUMX(
    FILTER(
    'S-CURVE_OVERALL',
    'S-CURVE_OVERALL'[Plan Date] <= EARLIER('S-CURVE_OVERALL'[Plan Date])
    ),
    'S-CURVE_OVERALL'[forecasted]
    )
    RETURN
    IF(cumul_forecasted = 0, BLANK(), cumul_forecasted)