Forum Discussion
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...
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
Hi drrai66,
You can use below dax formula to achieve the desired result.
A/B = Data[A] & "/" & Data[B]
Thanks,
Rahul