Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
code | post date | Line number | create date | model |
234 | 1/22/2020 | 20 | 7/6/2019 | r |
234 | 5/9/2019 | 10 | 2/4/2018 | g |
234 | 4/7/2020 | 40 | 1/4/2020 | n |
I selected code = 234 and it has 3 rows , I am looking for MIN value of Post Date which I will get MIN(post date ) it will be 5/9/2019 .
Requirement: (highlighted red )
how will I get the values like Line number (10) and Create date (2/4/2018) of the same row MIN post date (5/9/2019) in KPI.
=FirstSortedValue([Line number], [post date])
-Rob
Thanks Rob, I will try .