Forum Discussion
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
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.
Hi drrai66,
You can use below dax formula to achieve the desired result.
A/B = Data[A] & "/" & Data[B]
Thanks,
Rahul
3 Replies
Hi drrai66,
You can use below dax formula to achieve the desired result.
A/B = Data[A] & "/" & Data[B]
Thanks,
Rahul
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.
Worked Perfectly!!!
Actually you showed me a way. I did like this
Column =[A] & "/" & [B]
Thnaks
Deepak
