Forum Discussion

dirkkoch's avatar
dirkkoch
Icon for Helper III rankHelper III
4 years ago
Solved

Extract number with 10 digits from text column

Dear all,   I am struggling to find a way to extract a number from a text column in PBI. It is a consecutive number which always starts with 2700... and has 10 digits (eg. 2700102524 as shown in S...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    dirkkoch You should be able to do this:

    Column =
  VAR __search = SEARCH("2700",[POT1X],0)
RETURN
  IF(__search=0,BLANK(),MID([POT1X],__search,10))

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

dirkkoch You should be able to do this:

Column =
  VAR __search = SEARCH("2700",[POT1X],0)
RETURN
  IF(__search=0,BLANK(),MID([POT1X],__search,10))

 

dirkkoch's avatar
dirkkoch
Icon for Helper III rankHelper III
4 years ago

Greg_Deckler thanks for the quick support