Forum Discussion
Doesn't display October 1, 2017 - error
I've just seen this recently, when I'm trying to add in the Start of Month field, and could not see Oct 1, 2017 on the list but instead Sept 30,2017 is displayed. Please see screenshot below, the tab...
Still having the same issue, has someone encountered the same?
Not quite the same issue, but something probably similar (I have a post titled "April Fools?" on here which goes into detail).
Basically, my problem is I can filter my dashboard for ANY date, except 1 April, 2018. When I try that in a filter, everything disappears, almost as if it doesn't exist (which seems remarkably similar to your problem, particularly as yours is also a quarter start date.
I'm having to change my core SQL to create a derived field displaying the date in text (I'd rather do that than play with DAX in each PBIX file - easier doing it at source) and then update all my reports to use this field. Frustrating.