Forum Discussion

Jerush's avatar
Jerush
Helper I
3 years ago

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 ...
Jerush's avatar
Jerush
Helper I
3 years ago

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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