Forum Discussion
Helper IIStumped, cannot get min date
SOLVED
This is really crazy to me, so I would love an explanation from someone.
Data is such that a value for study_seq will always have the same value for title-id and vice-versa. I changed my formula to use title-ID which DOES appear in the table instead of study_seq. I now get the correct response.Someone, Ritaf1983 ? maruthisp ? please explain this too me.
Helper IIThank you both maruthisp and Ritaf1983
I am using a measure.
Update 3:45 PM EDT: I found a misplaced parentheses. Now that I have that correction, , to wit:
var vIAlsoDontWork = CALCULATE(min('Milestones Info'[StudyLevel Completed Date]), ALLEXCEPT('Milestones Info','Milestones Info'[STUDY_SEQ]))All rows return 01-Jan-1990, even though the earliest date for my study_seq is 19-Apr-2023.
I did just realize that my made-up sample does leave out a layer. The sample is more like this:
| study_seq | Milestone | Milestone level | Site Name | StudyLevel Comp Date | SiteLevel Comp Date |
| 52 | A | Study | Site 1 | 19-Apr-2023 | |
| 52 | B | Study | Site 1 | 28-Jun-2023 | |
| 52 | M | Site | Site 1 | 25-Nov-2025 | 25-Nov-2025 |
| 52 | N | Site | Site 1 | 28-Oct-2025 | 28-Oct-2025 |
| 52 | O | Site | Site 1 | 27-Nov-2025 | 27-Nov-2025 |
| 52 | A | Study | Site 2 | 19-Apr-2023 | |
| 52 | B | Study | Site 2 | 28-Jun-2023 | |
| 52 | M | Site | Site 2 | 25-Nov-2025 | |
| 52 | N | Site | Site 2 | 28-Oct-2025 | |
| 52 | O | Site | Site 2 | 27-Nov-2025 |
So you have the added complexity multiple site names. But I don't think this would affect the method of getting the Min date out of StudyLevel Comp Date.