Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Format Function - Decimal (Dot or Comma)

Hi Everyone,   Im having issues using the Format Function. The left columm is a regular setup using the options from powerbi, right column is me trying to use the format function but no matter what...
Need Help
Tips and Tricks
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous

I have tested by your formula, but not reproduce the issue.

This is your formula

Your = SWITCH(TRUE(),[Selected Currency]="USD",FORMAT([Turnover]/VALUES(Table2[Currency Rate]),"$0,00"),[Turnover])

and You could try this format

MY = SWITCH(TRUE(),[Selected Currency]="USD",FORMAT([Turnover]/VALUES(Table2[Currency Rate]),"$#,##0.00"),[Turnover])

If not your case, please share your sample pbix file, just need a little sample data.Do mask sensitive data before uploading

 

 

Best Regards,

Lin