Forum Discussion

zahlenschubser's avatar
zahlenschubser
Icon for Helper IV rankHelper 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
Icon for Helper IV rankHelper 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
Icon for Super User rankSuper 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.