Forum Discussion

jaigupta78's avatar
jaigupta78
Regular Visitor
5 years ago
Solved

convert sql to dax

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:- ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    jaigupta78 , a new column

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

amitchandak's avatar
amitchandak
Super User
5 years ago

jaigupta78 , a new column

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

jaigupta78's avatar
jaigupta78
Regular Visitor
5 years ago

Thanks Amit