Forum Discussion
Anonymous
6 years agoNot applicable
Like function in DAX
Hey guys, What is the equavalent of 'like' function of SQL in Power BI DAX. My USER ID data item sometimes contains more/less than 8 digits, but I want to get just the list of the ones that...
- 6 years ago
Anonymous , You can refer to these three
https://docs.microsoft.com/en-us/dax/containsstring-function-dax
https://docs.microsoft.com/en-us/dax/search-function-dax
https://docs.microsoft.com/en-us/dax/find-function-dax
For just 8 digits you can use len
amitchandak
6 years agoSuper User
Anonymous , You can refer to these three
https://docs.microsoft.com/en-us/dax/containsstring-function-dax
https://docs.microsoft.com/en-us/dax/search-function-dax
https://docs.microsoft.com/en-us/dax/find-function-dax
For just 8 digits you can use len
- Anonymous6 years agoNot applicable