Forum Discussion

chavanr's avatar
chavanr
Resolver I
5 years ago
Solved

Convert a text column to number

Hi there,

 

Can someone help with converting string to value.

string type is something like "AD1700000000000BC0081460"

 

I need it to convert it to number in order to get the count of each row.

 

Cheers,

 

 

 

 

Need Help

5 Replies

    • chavanr's avatar
      chavanr
      Resolver I
      5 years ago

      Thanks for your response ryan_mayu 

      I need it as a calculated column & then use it in a measure to show the total in bar cluster chart.

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        5 years ago

        chavanr 

        try to add a custom column in PQ

        =Text.Select([Column1],{"0".."9"})