Forum Discussion

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Calender table issue

I am using the below formula to create a calender table. Calender tabel =ADDCOLUMNS( CALENDAR(MIN(Date[Month_YR]),MAX(Date[Month_YR])), "Year",YEAR([Date]), "Monthn",MONTH([Date]), "Month",FORM...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi unnijoy ,


    I constructed the same data model, and then I can directly convert the "Month Year" field in the table from Text to Data type.

    Data Type

     

    For the modified date format, the column can only be displayed as text type, and powerbi currently only supports the date type format included by default.


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi unnijoy 

I can't reproduce the issue.  I set up a table called 'Date' containing a column called Month_YR and populated that with dates from 2020 to 2022.  The resulting Calendar Table has dates from 2020 right through to 2022.

What data have you got in your 'Date'[Month_YR] column?  If you are only getting dates in 2021 that would suggest that the earliest date you have in that table is in 2021. That's what the CALENDAR fucntion is picking up.

Please supply your data.

regards

Phil

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
5 years ago

hi PhilipTreacy ,

Below is the data set.

  • unnijoy's avatar
    unnijoy
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    this is the format.

     

    01-11-2020

  • unnijoy's avatar
    unnijoy
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    hi PhilipTreacy ,

     

    in the calender table month Year was in Text format. I change it to date. And in the format opetion i manually enter "mmm-yy"