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 table was generated using the Calendar function.
Does anyone enocunter the same problem?
14 Replies
Hi chocomart
One of my clients bought this to my attention and I was quickly able to repo it. I'm sure it's a bug.
Please review my repo added to this Issue report and if you agree then vote it up and add your comments to confirm, and highlight it's importance to the Product Team.
https://community.powerbi.com/t5/Issues/Bug-October-1/idc-p/400669
Well yes, the Product team already recognized it as an issue and they told me that it would be Fixed for this MAY Update. So let's wait and see if it indeed gets fixed for this month.
Thank you!
I'm seeing that it has been fixed in the May 2018 update.
I didn't encounter your issue. I created a calendar table with expression:
Calendar = CALENDAR(DATE(2017,01,01),DATE(2018,12,31))
And everything is working fine.
As you said that the table was generated using the Calendar function. How did you degine this function? Could you please share us your expression if possible? Also, please share us some sample data which can help us repro your issue. So that we can make proper tests.
Thanks,
Xi Jin.Hi Guys,
Thank you for your response, I'm just using the regular CALENDAR FUNCTION dating back from 2010 to 2018
Still working in my environment (Feb 2018 update Power BI desktop).
What's your version of Power BI desktop? You can verify the version at Help -> About. Maybe try to update it to newer version.
Thanks,
Xi Jin.
