Forum Discussion
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...
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.
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.
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.