Forum Discussion
Helper ILatest date per item
I have a list of numbers (ic. casenumbers) per casenumber several hearing have been planned on mulitple dates. I would like to show the last hearing date in a table. For example of the below list:
| Casenumber | Hearing date |
| CUR201701200 | 4-5-2017 |
| CUR201701201 | 8-5-2017 |
| CUR201800047 | 8-8-2018 |
| CUR201800696 | 6-8-2018 |
| CUR201801164 | 6-8-2018 |
| CUR201801165 | 8-9-2018 |
| CUR201701201 | 8-10-2018 |
| CUR201800047 | 9-9-2019 |
the table should show a a column with non identical casenumbers and the latest hearing date. Like case number CUR20180047 : 9-9-2018.
4 Replies
- parry2k
Super User
Steg add the following measure, change column and table name as per your model.
Max Date = CALCULATE ( MAX ( Table[Date] ), ALLEXCEPT ( Table, Table[Case Number] ) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
StegThe thing is, if I use your formula, I get a column with only one date, the last date registerd in the column Hearing date (in my example eg. 9-9-2019). What i need is a measure that results in a table like this (based on the example):
CUR201701200 4-5-2017 CUR201800696 6-8-2018 CUR201801164 6-8-2018 CUR201801165 8-9-2018 CUR201701201 8-10-2018 CUR201800047 9-9-2019
