Error when formatting number using FORMAT

[Jerush]

Hi All

I am trying to format a number in a certain format (space seperator) but getting an error.

Its a simple if statement, and the value that I want to format is a whole number.

Not sure what I am missing or doing wrong. 

Thanks everyone.

Regards,

Jerusha

[some_bih]

Hi @Jerush  on link you can find your example. Maybe "Standard" could fit your need. 

I hope this help

https://learn.microsoft.com/en-us/dax/format-function-dax 

[Jerush]

Hello @some_bih  
Thank you for the speedy reply. I need the values to read as 1 234 567  So need the a space as a thousandth seperator.

Thank you again.

Jerusha 

[v-cgao-msft]

Hi @Jerush ,

Please make sure that the output of the calculated columns is of the same data type.

Received = IF('Query1'[Mapping]="Premiums",FORMAT('Query1'[Amount],"### ###"),"0")

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum