Forum Discussion
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.2.2019 | open | |
| 2565 | 28.3.2019 | open | |
| 2565 | 15.10.2019 | closed | |
| 1534 | 14.2.2019 | open | |
| 1534 | 25.5.2019 | open | |
| 1534 | 15.10.2019 | open |
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] )
3 Replies
- amitchandak
Super User
Try to create category Min. ask Close is smaller than open it should work
Refer
https://community.powerbi.com/t5/Desktop/MIN-value-based-on-common-ID-number/td-p/247535
v-chuncz-msftCommunity Support
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] )
