Like function in DAX

[Anonymous]

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 have 8 digits. 

Which function can help me with that?

Thanks, 

Sona

[amitchandak · Accepted solution]

@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

https://docs.microsoft.com/en-us/dax/len-function-dax

[Anonymous]

Hey @amitchandak , 

Containsstring function helped me with the issue. 

Thanks, 

Sona