topic Re: Convert SQL to DAX in DAX Commands and Tips

Convert SQL to DAX

rolinx — Thu, 30 Mar 2023 09:42:16 GMT

Please, I need help about how to convert this SQL query to DAX.

select col1, col2, col3
from tab
where length(col1) = '10'
or (substr(col2,1,3) in ('103','234','563')
or (substr(col2,1,4) in ('1034','2354','5636')
or (substr(col2,1,2) in ('14','24','36')

Re: Convert SQL to DAX

lbendlin — Fri, 31 Mar 2023 23:34:43 GMT

CALCULATETABLE(<your table>,

LEN([col1])=10
|| MID([col2],1,3) in {"103","234","563"}

|| MID([col2],1,4) in {"2354"}

|| MID([col2],1,2) in {"14","24","36"}

)

You can add SELECTCOLUMNS if you want. Note that your third condition is semi redundant.

Re: Convert SQL to DAX

rolinx — Sat, 01 Apr 2023 00:48:46 GMT

Thanks Ibendlin, Its works fine!
Its works also with LEFT function.

CALCULATETABLE(<your table>,

LEN([col1])=10
|| LEFT([col2],3) in {"103","234","563"}

|| LEFT([col2],4) in {"2354"}

|| LEFT([col2],2) in {"14","24","36"}

)