Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |