convert sql to dax

[jaigupta78]

Hi 

Please help in converting SQl to DAX  

select j.Col1, j.Col2 , (select Min(Col2) from Table1 where Col1 = j.Col1 and Col2 > j.Col2) as Col3
from Table1 j

Table1 has following Columns:- Col1 int, Col2  date  

[amitchandak · Accepted solution]

@jaigupta78 , a new column

minx(filter(Table, [Col1] =earlier([Col1]) && [Col2] >earlier([Col2])), [Col2])

[jaigupta78]

Thanks Amit