Forum Discussion
Potential bug with date() ?
- 2 years ago
I have the weirdest fix for this ... switch back the regional settings in PBI to the default.
A little annoying, but trying to figure out and fix what PBI messes up in the background is way worse.
Hi zahlenschubser
When I opened the file there were a couple of errors because of dots instead of commas on the formula not sure if this is happening also to you but please see then image below:
After replacing this by commas everything worked properly even after saving, opening and reopening.
That's because command separators are set to comma in the regional settings.
I changed something in the formula and back and let it calculate and got a result
But as soon as I save it bugs out again
It doesn't even show me any errors in the code / code window, just the cryptic message on the bottom.