Forum Discussion
Latest date and Condition/filter
Solution SupplierAre you looking to get this as a measure to go on the table provided in your original post? Or are you just after another table list that shows the latest date for a code review on each ticket ID?
If it's the latter, no DAX would be needed, you could just make a new table with these 3 columns. Change the "Last Updated" Values on the visual to show "Latest" by clicking on the dropdown arrow for it,. Then filtering the visual to show only Code Review.
(Made a slight change on your provided data to show Key-2's Code Review a minute later than Key-1's to show it is picking up a different one).
I'm looking to display this as a single card and distributed in time.
The above wouldn't work as Key-1's latest status is not Code Review but Closed. So from my table, I would need to bring back only Key-2 since it's latest status is 'Code review'.
I don't need the latest date of 'Code Review', I need the items that have their last status 'Code Review'.