- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Find Earliest Date on Filtered Set of Values in Table
I need to find the earliest date in my data, for Each Job No and PhaseID but exclude from my result any dates that are 12/30/1899.
Here is a sample of my data -
I have tried various solutions, but none seam to provide the result. I was able to get the result be creating a new column called 'SchedStartDateFiltered' which uses a conditional statement to return the ScheduledStartDate or blank if = 1899 and then use a measure formula, but I need to create this as a column with a DAX statement so I can use it in my matrix table.
Help is appreciated!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

you can also try this
Column = MINX(FILTER('Table','Table'[schedulestartdate]<>date(1899,12,30) && 'Table'[jobno]=EARLIER('Table'[jobno])&&'Table'[phaseid]=EARLIER('Table'[phaseid])),'Table'[schedulestartdate])
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

you can also try this
Column = MINX(FILTER('Table','Table'[schedulestartdate]<>date(1899,12,30) && 'Table'[jobno]=EARLIER('Table'[jobno])&&'Table'[phaseid]=EARLIER('Table'[phaseid])),'Table'[schedulestartdate])
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

If I want to do the same but only filter on Job No and not inclde Phase ID, can you provide me the adjustment? The solution you provided works perfectly, I just want the option. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

you can try this
Column = MINX(FILTER('Table','Table'[schedulestartdate]<>date(1899,12,30) && 'Table'[jobno]=EARLIER('Table'[jobno])),'Table'[schedulestartdate])
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @vincenardo ,
Please try this as a measure:
MinDate = CALCULATE(MIN(YOUR_TABLE[ScheduleStartDate]), ALLEXCEPT(YOUR_TABLE,YOUR_TABLE[Job No]),YOUR_TABLE[ScheduleStartDate] <> DATE(1899, 12, 30))
Alternatively, you can do the same in a calculated column:
MinDate = CALCULATE(MIN(YOUR_TABLE[ScheduleStartDate]), FILTER(YOUR_TABLE, YOUR_TABLE[Job No] = EARLIER(YOUR_TABLE[Job No]) && YOUR_TABLE[ScheduleStartDate] <> DATE(1899, 12, 30)))
Let me know if that works out for you.
Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
12-14-2023 06:13 AM | |||
10-10-2018 07:19 AM | |||
06-13-2023 05:37 AM | |||
04-11-2024 04:01 AM | |||
03-27-2024 07:56 AM |
User | Count |
---|---|
90 | |
82 | |
57 | |
41 | |
39 |