Forum Discussion

unascimento's avatar
unascimento
Frequent Visitor
4 years ago
Solved

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

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 conv...
Need Help
Tips and Tricks
Tutorial Requests
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

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.