Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Same number - different status

I have the same number multiple times. And I wonder which formula I can use that the Finalstatus is for all  2565 = closed is for all 1534 = open IssueID Date Status FinalStatus 2565 14...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Anonymous 

     

    You may use the following DAX to add a calculated column.

    Column =
MAXX (
    TOPN (
        1,
        FILTER ( 'Table', 'Table'[IssueID] = EARLIER ( 'Table'[IssueID] ) ),
        'Table'[Date], DESC
    ),
    'Table'[Status]
)

     

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous 

 

You may use the following DAX to add a calculated column.

Column =
MAXX (
    TOPN (
        1,
        FILTER ( 'Table', 'Table'[IssueID] = EARLIER ( 'Table'[IssueID] ) ),
        'Table'[Date], DESC
    ),
    'Table'[Status]
)