Forum Discussion

Russ99's avatar
Russ99
Icon for Helper I rankHelper I
4 years ago
Solved

month recognised as text

Hi,

 

My data set has a column called month in which the records are formated "mmmm". there is no day or year attached to each record.

 

I am trying to convert data type from text to date format but i keep getting an error, does anyone know how to solve this? I want to be able use the month on a line chart.

 

thanks

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Russ99 ,

    you can create new table (enter data) with date format (e.g. 1.1.2022, 1.2.2022 etc.), add column with month as text.

     

    Than add column with formula =FORMAT(DateTable[Date], "mmmm"). It will write the full name of months in date format. And you will be able to use this column in your charts.

2 Replies

  • AilleryO's avatar
    AilleryO
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi,

     

    If you want to use a date format, you need to have a complete date, ie the 3 items thhta makes a date : day/month/year.

    If you have only the month it's not a date (its a part of a date), so you cannont apply a date format to it.

    Do you have a column with a real date ?

    If not maybe you can duplicate a column to get a proper date ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Russ99 ,

    you can create new table (enter data) with date format (e.g. 1.1.2022, 1.2.2022 etc.), add column with month as text.

     

    Than add column with formula =FORMAT(DateTable[Date], "mmmm"). It will write the full name of months in date format. And you will be able to use this column in your charts.