Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Setting a field to null based on another field's value

Hey Everyone,   Background: I'm pulling team sprint data from Jira cloud and want to show what stories the team completed within a sprint. This is easy to do when a story is completed within a sin...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    You can add a calculated column.

    Completeed Date2 =
IF (
    TB3[Sprint] = CALCULATE ( MAX ( TB3[Sprint] ), ALLEXCEPT ( TB3, TB3[Story] ) ),
    TB3[Completed Date],
    BLANK ()
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

You can add a calculated column.

Completeed Date2 =
IF (
    TB3[Sprint] = CALCULATE ( MAX ( TB3[Sprint] ), ALLEXCEPT ( TB3, TB3[Story] ) ),
    TB3[Completed Date],
    BLANK ()
)

 

Best regards,

Yuliana Gu