Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have column like below.
I want to find customer number (e.g.39965929 -> in above example).
How to do this?
Maybe use FIND() function?
Check :https://docs.microsoft.com/en-us/dax/search-function-dax
@amitchandak
Ok, but I need to find value between fourth and fifth space.
How to do this?
Hi @pawelj795 ,
You need a calculated column as below:
Column =
var a = SEARCH(" ",'Table'[Column1])
var b = SEARCH(" ",'Table'[Column1],a+1)
var c = SEARCH(" ",'Table'[Column1],b+1)
var d =SEARCH(" ",'Table'[Column1],c+1)
var e =SEARCH(" ",'Table'[Column1],d+1)
Return
MID('Table'[Column1],d+1,e-d)
And you will see:
For the related .pbix file,pls click here.
Best Regards,
Kelly
@v-kelly-msft
I think I know what creating problem.
I have some rows without 5th space.
Is there any solution to get round this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |