Forum Discussion
Can't input calculated column formulas
Thanks for the reply but I get the same kind of problem with semi colon as well.
When you type "DATE(" they show you a grey popuplike in the image bellow, with the correct syntaxe. Show us this popup
- rafaelmpsantos7 years agoResponsive Resident
I think that for some reason, your computer List Separator was changed.
To fix it... Go to Control Panel>Region>Click Additional Settings> and Change List Separator to comma., apply and ok...Close your pbi file and open again and it will be fixed.
If this solve your problem mark as solution, and send me a feedback with your Like in this post.
- Zubair_Muhammad7 years agoCommunity ChampionI see that column name starts with 1 which is not allowed
Try removing that 1- rafaelmpsantos7 years agoResponsive Resident
its not 1, but the new DAX editor from October 2018
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-2018-feature-summary/#daxEditor
- dyrefors7 years agoNew Member
Unfortiunatly the gray help popup says to use commas han the List separator setting was already set to a comma. I tried changing it to semi colon instead and that seems to work, so I guess I'll use semi colon for a wile.
Thanks for the help everybody!
- rafaelmpsantos7 years agoResponsive Resident
Try another time to restart your computer and change again to comma.
- rafaelmpsantos7 years agoResponsive Resident
In Regional Settings, look if decimal separator is setting to point...if both, Decimal and List are comma you may have problems.