Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
78 | |
75 | |
62 | |
60 | |
47 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |