Measure to find Min date in filtered table within group

[Txtcher]

I am trying to use dax to find the min created date within the ParentID group for NewValue = [Approved] (actually I will need the min date for all of the different values in the NewValue column for each ParentID group.

PQ editor makes it easy to aggregate data, but there are too many records and it takes hours. 

I am quite new to PBi/DAX. I have used DAX a wee bit in the Excel Data Model, but nothing fancy. 

Here is a screen shot of the model (I created a date table for the FY we need data for.)

For each different value in the NewValue column, I need to find the min date. Then I want to add that to my report table.

I tried this:

License Issued = CALCULATE(

    Min([CreatedDate]),

            ALLEXCEPT('HX','HX'[ParentId]))

But when I add that to the report table, it repeats the data in in the first 2 columns that come from the NFA Apps table, and the Submitted and Paid that comes from the FEES table, and I haven't checked if that is correct. And the data in the License Issued is all the same date. 😞 

[Txtcher · Accepted solution]

Solved it!

License Issued = CALCULATE(

    Min([CreatedDate]),

    FILTER(HX,[NewValue]="Approved"),

            ALLEXCEPT('HX','HX'[ParentId]))