Forum Discussion
Can't input calculated column formulas
It is caused by the Config of Region in you windows. If The decimal number is set to use coma you cannot use it to in you dax formula, you need to use semicolon.
Thanks for the reply but I get the same kind of problem with semi colon as well.
- rafaelmpsantos7 years agoResponsive Resident
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
- 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.