Forum Discussion
Currency formatting in power query editor
Hi, I am trying to format a field "Actuals" to currency in query editor. Unlike desktop, I don't see how to set the format for the field to currency. I am trying to do this in power query so that wh...
Anonymous
You can use format() in Desktop to set measure format to currency. For example: Measure= FORMAT( sum([data]), "Currency")
FORMAT function (DAX) - DAX | Microsoft Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly
Thanks, it did let me carry the currency format on measures when I am changing the datasource. But looks like this method is changing the feild to text and therefore when I am trying to do a feild formatting for negative values to be displayed in red colour, its not working.