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.
Hi,
Started working with power bi not a long time ago, and I'm struggling with the following calculation:
I have a column that contains mixed numbers and text – all values in the column are text.
For example:
col
4
4
3
CDB
2
1
ABC
I need to copy the "numerical" values to a new column as numbers.
New_col
4
4
3
-
2
1
-
Unfortunatly In this model I can't use power query.
Solved! Go to Solution.
Refreshing didn't solve it?
Also, for testing, try doing the same outside of Tabular Editor.
If you have to do this in DAX (calculated column),
Add the column
=IFERROR(VALUE([A]),BLANK())
Where [A] is the original mixed column.
Thank you for you response,
I wrote the query in Tabular editor (calculated column)- >
IFERROR ( VALUE ( Fact_FormAnswerRows[Selected Answers] ), BLANK () )
And when I checked the results in PB the following error was showcased:
I'm not sure if there is something not current in my query or is it something else?
Refreshing didn't solve it?
Also, for testing, try doing the same outside of Tabular Editor.
Thanks!
In the end it worked 🙂
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |