Forum Discussion
jaigupta78
5 years agoRegular Visitor
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:- Col1 int, Col2 date
jaigupta78 , a new column
minx(filter(Table, [Col1] =earlier([Col1]) && [Col2] >earlier([Col2])), [Col2])
2 Replies
- amitchandakSuper User
jaigupta78 , a new column
minx(filter(Table, [Col1] =earlier([Col1]) && [Col2] >earlier([Col2])), [Col2])
- jaigupta78Regular Visitor
Thanks Amit