cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drrai66 Member
Member

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 VALUE  as above

 

Thanks

Deepak

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Convert text to number

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])

image.png

 

Which then has the following result.

image.png

 



Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
RahulYadav Regular Visitor
Regular Visitor

Re: Convert text to number

Hi @drrai66,

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

 

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

Thanks,

Rahul

3 REPLIES 3
Super User
Super User

Re: Convert text to number

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])

image.png

 

Which then has the following result.

image.png

 



Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
RahulYadav Regular Visitor
Regular Visitor

Re: Convert text to number

Hi @drrai66,

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

 

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

Thanks,

Rahul

drrai66 Member
Member

Re: Convert text to number

Worked Perfectly!!!

Actually you showed me  a way. I did like this

 

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

Thnaks

Deepak