Forum Discussion

unnijoy's avatar
unnijoy
Post 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
Super User
5 years ago

Hi unnijoy 

In your initial post your code showed that you were creating the Calendar Table using the MIN and MAX dates from a table called Date

CALENDAR(MIN(Date[Month_YR]),MAX(Date[Month_YR]))

But your latest post shows that you are actually using the MIN and MAX dates from the table[column] called Errors[Month_YR] - what data is in that column?  That's what is detemining the dates/years you get in your Calendar.

Regards

Phil