Forum Discussion

drrai66's avatar
drrai66
Resolver I
8 years ago
Solved

Convert text to number

Hi All, I have 2 WHOLE NUMBER COLUMN LIKE A and B. I want To Create another  TEXT COLUMN Like THIS: A/B   So if A    B    A/B   1     3    1/3   4     6     4/6   A/B should return TEXT...
Need Help
  • GilbertQ's avatar
    GilbertQ
    8 years ago

    Hi drrai66

     

    I would go into the Power Query Editor, then click on Add Column in the Ribbon.

    Then click on Custom Column and put in the following code below.

    NOTE: This will work as long as your columns A and B are set to a data type of Whole Number

    Text.From([A]) & "/" & Text.From([B])

     

    Which then has the following result.

     

  • RahulYadav's avatar
    RahulYadav
    8 years ago

    Hi drrai66,

    You can use below dax formula to achieve the desired result.

     

    A/B = Data[A] & "/" & Data[B]

    Thanks,

    Rahul

GilbertQ's avatar
GilbertQ
Super User
8 years ago

Hi drrai66

 

I would go into the Power Query Editor, then click on Add Column in the Ribbon.

Then click on Custom Column and put in the following code below.

NOTE: This will work as long as your columns A and B are set to a data type of Whole Number

Text.From([A]) & "/" & Text.From([B])

 

Which then has the following result.

 

  • drrai66's avatar
    drrai66
    Resolver I
    8 years ago

    Worked Perfectly!!!

    Actually you showed me  a way. I did like this

     

    Column =[A] & "/" & [B]

    Thnaks

    Deepak