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 i do it gives me "." instead of "," . All my settings are in english (USA)
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
thanks for taking the time to help me, i run your formula and the error persist. This are my settings, maybe the OS config is the one giving the trouble?
how can i send you the sample?
please update the latest version power bi desktop ( 2.65.5313.841 ) then try it again.
You may also try to change region setting as these similar posts:
If not your case, please upload sample pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.