Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
I would just add a new column in the one table that will be used for calculations.
try Number.From([Value]) otherwise null
I would just add a new column in the one table that will be used for calculations.
try Number.From([Value]) otherwise null
Never thought of that. Great simple solution @Anonymous
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |