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. I have a column of prices which is formatted as 1,234.567 when in reality it is 1,234,567 (x 1,000). How do I convert it so that it reflects the actual values? Thanks!
Solved! Go to Solution.
@Anonymous -
Something like
Column = VALUE(SUBSTITUTE(TableName[Column1],".",","))
work for your need?
Proud to be a Super User!
You can create a new column
column B = Table[column A]*1000
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Have you tried creating multiplying the number by 1000?
Proud to be a Super User!
@Anonymous -
Something like
Column = VALUE(SUBSTITUTE(TableName[Column1],".",","))
work for your need?
Proud to be a Super User!
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 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |