Forum Discussion

chocomart's avatar
chocomart
Icon for Helper I rankHelper I
8 years ago

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...
v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

chocomart

 

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.

chocomart's avatar
chocomart
Icon for Helper I rankHelper I
8 years ago

Hi Guys,

 

Thank you for your response, I'm just using the regular CALENDAR FUNCTION dating back from 2010 to 2018

 

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Icon for Solution Sage rankSolution Sage
    8 years ago

    chocomart

     

    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.

    • chocomart's avatar
      chocomart
      Icon for Helper I rankHelper I
      8 years ago

      Hi v-xjiin-msft

       

      here is my version number, I'll try to update first then will try again.

       

      • chocomart's avatar
        chocomart
        Icon for Helper I rankHelper I
        8 years ago

        Hi,

         

        Just updated mine to the latest version,

         

        but still facing the same issue.