Forum Discussion

zahlenschubser's avatar
zahlenschubser
Helper IV
2 years ago
Solved

Potential bug with date() ?

I have a very curious issue with a switch function containing a lot of date() formulas. What I am trying to do is get a column that shows me when one of our invoicing groups will be billed next, mos...
Need Help
  • zahlenschubser's avatar
    zahlenschubser
    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.

     

zahlenschubser's avatar
zahlenschubser
Helper IV
2 years ago

What confuses me in your screenshots is that PBI seems to have replaced only a part of the separators with dots, not all of them. If that's what goes on in the background on saving it's no wonder it bugs out.

MFelix's avatar
MFelix
Super User
2 years ago

Hi zahlenschubser ,

I have to be honest in the past (2017/2018) this would happen when we had a computer with regional settings and got a file with different regional settings and then DAX editor would become "confused". We even got problems when copying formulas to the forum because some people got the decimal separator has comma or has dot.

Since they added the functionality for the regional settings and the DAX defnitions I never seen this again. I know this will sound stupid but can you try and replace the dots by comma but be sure to add a space after the comma:

if you have 6.7 you should go to 6, 7

 

See if that picks up the correct values or goes back to giving you errors.