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.

     

MFelix's avatar
MFelix
Super User
2 years ago

Have to be honest, PBI Desktop always messes up with the regional settings not sure why but it does, since back way in 2015 when it all started.

 

If that fixed your issue please remember to accept the solution so it can help others.

zahlenschubser's avatar
zahlenschubser
Helper IV
2 years ago

It's not really a solution if I have to undo parts of the program setup to fix an underlying coding issue, but for the sake of getting it resolved on the user side I'll mark it anyway.

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Has I refered the DAX syntax and the regional settings always have been struggling together not sure why but they have.

     

    I always keep the default for DAX syntax that way won't get into any problems.