Extracting the last date in a column based on the data in another using a measure

[DreDre]

I have a table with one column containing repeating values or "Source" and another column containing just the “Date” for each record. I am trying to display the first/last date for each “Source”, but when I use the following formula I get a date in the middle of the range. I am newer to PBI so any help would be greatly appreciated! Below is a sample of the data I am talking about.

Date - End = DATEVALUE(Calculate(Max('Data Source'[Date])))

Date - End = max('1 Date Source'[Date])

Source	Date	Type
Month 1	1/12/2020	AOH
Month 1	1/13/2020	AGN
Month 1	1/14/2020	QXP
Month 1	1/15/2020	AOH
Month 1	1/16/2020	QXP
Month 3	3/23/2020	AGN
Month 3	3/24/2020	QXP
Month 3	3/25/2020	QXP
Month 3	3/26/2020	AOH

 same for Date - Start, just using Min

How would I say that Month 1 was from 1/12/2020 – 1/16/2020 and month 3 was 3/23/2020 – 3/26/2020? I tried using a table visualization and adding the Values of “Source”, the measure I made “Date – Start” and “Date – End”, but I am getting Month 1 1/15 – 1/15 and month 3 as 3/24 – 3/24.

[Greg_Deckler]

@DreDre - You should just need to do MIN and MAX assuming that your column is really a date column and not text for example. 

[DreDre]

@Greg_Deckler - When using the Min/Max, it ends up pulling a date in the table that matches the "Source" but is the same date for the Start/End which is where I am hitting the wall. The column is filtered as a date which I thought would be the fix, but I am still stumped. 

[Greg_Deckler · Accepted solution]

@DreDre - Perhaps I am not understanding what you are going for here. See attached PBIX, is that what you want?

[DreDre]

@Greg_Deckler I went to create a sample of what I was trying to explain and your right it looks like the min/max do work exactly as they should have so there is a problem with my underlying data that I need to root out. I appreciate your quick response!