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 ...
@Dax Measure Error
Desktop version
  • 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