Count based on Min / Max Date by Quarter

Anonymous, dkay84_PowerBI,

Thanks for both of your responses. I ended up going a different route. Anonymous, I could never get your example to work properly. 

I ended up making a secondary table that only included the max and min dates (SQL Query). I then used the LOOKUPVALUE function to pull that min/max date respectively in my overall table. I then compared the file date in that table to the min/max date and used "yes" or "no" if it matched that date (as another column in the raw data file).

I then more simply created a calculation (measure) that filtered in those that were "yes". 

I appreciate your assistance in responding. 

Jonathan