Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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')
Solved! Go to Solution.
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.
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.
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"}
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
65 | |
50 | |
45 | |
20 | |
17 |