Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 , 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
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |