I cannot convert PreTaxCost column (CSV export billing cost management) to USD format.

[unascimento]

Hello, I have a process running where I export the Azure billing (Cost Management) to a blob where I use PowerBI Conecto and transform the csv into a table.

However, I have difficulty in how to convert the PreTaxCost and Resource Rate field to USD currency so that the values presented can make sense.

Can you help me with any suggestions, dax, etc?

i need to see in report with $1.000,00 (EXAMPLE)

Thank you

[v-jingzhang · Accepted solution]

Hi @unascimento 

Your PreTaxCost column is of Text type in Power Query editor. First change its type to Fixed decimal number. Then apply the change and go to Power BI Desktop. Select this column and under Column tools tab, change its format to Currency and select "$", "," icons to format it. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Gabriel_Walkman]

Yes, the numbers seem strange. Nevertheless, from your screenshot can be seen that the column type is set to text (the small abc icon). Change it to ie. decimal. Then have a google how to change the column format settings. 

[AlexisOlson]

Are your rates really in the trillions? These numbers look weird to me regardless of column formatting.