Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
My data source has numbers like: 2.0458e+2 and 3.0465e-4
They are currently being read as text, changing collum type in the query editor is not working
How do i make power BI read them as a numeric value?
Solved! Go to Solution.
BTW, I entered those numbers into an Enter Data query and M converted them. Here is my query:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtIzMDG1SNU2UorViVYyBvLMTFN1TZRiYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [eNumbers = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"eNumbers", type number}}) in #"Changed Type"
You may have to parse it by keying on the "e" and calculate it manually.
BTW, I entered those numbers into an Enter Data query and M converted them. Here is my query:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtIzMDG1SNU2UorViVYyBvLMTFN1TZRiYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [eNumbers = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"eNumbers", type number}}) in #"Changed Type"
Hi,
I have a issue about some numbers in a column (messure numbers), maybe you can help me out.
changing collum type in the query editor and modeling is not working
How do i make power BI read them as a numeric value?
this picture above is an example the numbers should be.
Thank you
Best regards
Seb
User | Count |
---|---|
77 | |
76 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |