Convert text to number

[drrai66]

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

[GilbertQ · Accepted solution]

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 · Accepted solution]

Hi @drrai66,

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

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

Thanks,

Rahul

[GilbertQ · Accepted solution]

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]

Worked Perfectly!!!

Actually you showed me  a way. I did like this

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

Thnaks

Deepak