Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Expression in power pivot syntax considered incorrect - syntax gets changed
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 93%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dodhoest
0
Reputation points Microsoft Employee
Dear Community, Hoping to get your help... I am trying to create a new measure for my power pivot where I use the datesinperiod function. I enter the formula correctly (see snip below) but somehow excel recognizes my last comma as a dot and refuses to work with the expression. I have tried replacing the comma by a dot, a dot-comma,.. etc to try and make it work.. it doesn't. I have also tried changes my language settings in excel in the hope to solve the problem. It doesn't. Did anybody ever experience this? Would be great to get your insights! Thank you
Microsoft 365 and Office | Excel | For business | Windows
{count} votes
-
Viorel 125.7K Reputation points2023-08-03T20:02:15.9933333+00:00 Did you also try to insert some spaces:
-12 , month? -
Dodhoest 0 Reputation points Microsoft Employee
2023-08-04T08:43:56.2366667+00:00 Yes, and that works, brackets also work.. yet what I would like to understand is why I cannot use the same formula's as my colleagues..? Would you have any ideas?
Thank you for your reply!
-
Viorel 125.7K Reputation points
2023-08-04T10:47:06.66+00:00 For some reasons (probably based on Regional settings), it believes that “,” is a decimal or group separator. It expects digits after “-12,”.
Sign in to comment
Sign in to answer