Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
127 | |
108 | |
100 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |