Forum Discussion
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 have 8 digits.
Which function can help me with that?
Thanks,
Sona
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
2 Replies
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