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.

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
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.