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.
In my table, "2a" is a character string. I would assume that would mean putting it in the VALUE function would return an ERROR but actually it returns 0.0833333. Does anyone know why??
Solved! Go to Solution.
Yes the other solution worked for me, thank you! I was just curious about why exactly the "a" was allowed to be converted to a number. Thanks again!
Hi @aallman
Seems like the letter "a" represents the angle in Radians that its SIN = its value i.e. ( SIN ( a ) = a ) which is 0.0416667 rad = 1/24 rad = 2.3873 degrees. If preceded by a number (X) where 0 < X < 24 the result of VALUE is just the multiplication of X times a. This has something to do whith 1 hour per 24 hours a day (1/24).
The bottom line it does not matter just ignore it.
Have the solution I provided in your other post worked with you?
Have a good day.
I don't think multiples of an angle a is quite the right interpretation since "a" by itself doesn't get interpreted and "23a" is fine whereas "25a" returns an error.
You are on the right track with 24 hours per day. It's interpreting "2a" as "2:00 AM".
Here are some additional examples where I've included another copy of the column formatted as a Time column:
Yes the other solution worked for me, thank you! I was just curious about why exactly the "a" was allowed to be converted to a number. Thanks again!
@aallman , Refer doc, what all can happen with text datatype
https://docs.microsoft.com/en-us/dax/value-function-dax
See also this documentation including relevant examples related to time:
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 |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |