Best practice to deal with column mixed value/text

[jpt1228]

Hello, I am working on a new data model and I have a column that has text, whole numbers, and decimal numbers. I need to create calculations with the numeric values in this column but can't convert column type to value due to text in column - Which I may need the text.

Should I pivot the column into seperate columns by value type or create 3 different tables - Each filtered on the data type: Table1 then reference Table1 and filter column for text rename table Table1text, Reference Table1 and filter column for whole number and rename Table1wholenum for each data type?

Thanks

[Anonymous · Accepted solution]

I would just add a new column in the one table that will be used for calculations. 

try
Number.From([Value])
otherwise
null

[jpt1228]

Never thought of that. Great simple solution @Anonymous