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 Community,
I connected to the source data through the online mode of the AAS model in Power BI, so I am not able to change formats of the datasets using the conventional ways (power query, for instance). Before doing the calculation, I need to convert the string to numerical value. For that, I used "Format", "value", or "convert", none of them worked for me because I cannot find the column in those formulas. For example, I have a string column "201908" and want to convert a value of 201908. Thank you.
Solved! Go to Solution.
@qsong - Use MAX or MIN
Finally I used VALUE(MAX()) to refer the column names, and it works for me.
Thank you.
@qsong - Try [Column] * 1
Hi @Greg_Deckler,
Thank you for your suggestion.
I cannot find the column except I have to add something like sum before the column; However, column has a string value, so sum does not work on the case.
Best, Qianru
@qsong - Use MAX or MIN
Hi Greg,
I need to convert 123-45-789-0 is kind of string format data to number format ,could you please help me .
I need to logic to get additional values result
For example,
AI Col-A Col-B Result
A 123. 123. Equal
A 123. Extra
I need to get extra for same document A
Finally I used VALUE(MAX()) to refer the column names, and it works for me.
Thank you.
@qsong , are you using live connection? Otherwise, you can simply change the data type to the number and it should work as long as all values in the column are number
I am using the live connection. So I cannot use power query to make the change.
Hi @qsong ,
Can you share the screenshot of your table and the column you want to convert.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @harshnathani,
I have a string column called calendar_month_key, and I want to convert it to be a numerical column called PP. As I described the background before, I am not able to do the format conversion in power query or by creating a calculated column because of the particular source connection.
Currently, I am using the conditional statement for the conversion which consumes a lot of memory. So I cannot have enough space for further calculation.
Thank you.
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |