Forum Discussion
Find value in column
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?
5 Replies
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
