Forum Discussion
Apply Standard number operation on multiple columns
Hi everyone,
i have a number of columns which are presented in thousands from the source data. i want to transform them to millions in my query editor.
I know that i can do one at a time but i want to apply all at one go. apprently, the system will grey out the Standard numeric operation when i selected multiple columns.
Is there a faster way to do this?
2 Replies
- amitchandak
Super User
ivank8383 , Please refer if this can help
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
What is the source data format?
v-zhenbw-msftCommunity Support
Hi ivank8383 ,
Sorry for that Power BI cannot convert multiple columns at once.
Maybe you can use the FORMAT function to convert it, or you can configure the Field Formatting.
Please refer the following post and screenshot.
https://community.powerbi.com/t5/Desktop/Convert-Amount-K-to-Million/td-p/326482
If you have any question, please kindly ask here and we will try to resolve it.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
