Get min date, from group with if statement

[arutsjak90]

Hi, I want to create additional column, which will show minimum date from DATE column per Group where Check column is equal to "OK".

Group	Date	Check	MinDate
1	01/01/2020		01/02/2020
1	01/02/2020	Ok	01/02/2020
2	01/05/2020		01/06/2020
2	01/06/2020	Ok	01/06/2020
2	01/07/2020	Ok	01/06/2020

[arutsjak90]

Perfect, thank you @Anonymous! 

[Anonymous · Accepted solution]

@arutsjak90  if you are open to other functions than "If", following DAX can be used to create the calculated column: 

Min_date = CALCULATE(MIN([Date]),

FILTER(Table, Table[Check]="Ok"

&& Table[Group]=EARLIER(Table[Group])))

Did I solve your problem?

If yes, please mark my answer Accepted! 

[DataZoe]

@arutsjak90 For a DAX measure it would be:

MinCheckDate =
IF (
    ISBLANK ( SELECTEDVALUE ( MinCheckDate[Group] ) ),
    BLANK (),
    CALCULATE (
        MIN ( MinCheckDate[Date] ),
        MinCheckDate[Check] = "Ok",
        REMOVEFILTERS ( MinCheckDate[Date] )
    )
)

[arutsjak90]

Thank you, but I am getting circular error. 

[DataZoe]

@arutsjak90 Can you share the DAX for PSI[WhentotalIsGreater]? What I had shared actually assumes the other columns are not measures or calculated columns themselves. 

[arutsjak90]

First, there is "running total" column

Running Total Plus = CALCULATE(

SUM(PSI[ Rec./reqd.qty]),

FILTER(

PSI,

'PSI'[Plant&Material]=EARLIER(PSI[Plant&Material])

&& PSI[NewDate] <= EARLIER(PSI[NewDate])

)

)

then is 

WhenTotalIsGreater = IF(PSI[Running Total Plus]>PSI[CurrentStock],"Check","")