Forum Discussion
Error when formatting number using FORMAT
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
3 Replies
Hi Jerush on link you can find your example. Maybe "Standard" could fit your need.
I hope this help
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 TeamIf 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
