Getting year month from created field of sharepoint list

[Nona]

Hello, probably very easy for other people but I cannnot find any solution by googling..

my report is connected to Sharepoint list and have a field [Created] which shows like this in the table [17/09/2020 22:00:00].

I would like to get [Month] and [Year] in separate column.  can anyone advise me ?

[jdbuchanan71]

@Nona 

If you want them in 1 column you could do 

Month Year = FORMAT ( 'YourTable'[Created], "mmmm yyyy" )

If you want them in seperate columns you would do 

Year = YEAR ( 'YourTable'[Created] )

Month = MONTH ( 'YourTable'[Created] )

[Nona]

Thank you very much for your reply !.  I tried year and month (separate)  this works very well, thank you!

but when I tried below, I get exactly same result as created field.

Month Year = FORMAT ( 'Community Questions'[Created], "mmmm yyyy" )

This is what I entered.

Month Year = FORMAT ( 'Community Questions'[Created], "mmmm yyyy" )

and I got this in the new column

18/09/2020 12:39:15

which is exactly same value as [Created] field.

Did I do something wrong ?

[jdbuchanan71 · Accepted solution]

I don't know why it is doing that.  When I test it on my side it works:

Can you share your .pbix (load it to drop box or one drive and share the link)?

[Nona]

Sorry! I found why it does not work.  it was just the data type.  I had text and I changed to date and time format, then your solution works.(of course!)

Thank you very much !

[Nona]

Hi. I was just preparing to send you .pbix.(thank you very much for your offer), and export the data from sharepoint list to excel and created a copy of .pbix exactly the same but the data source is not sharepoint online but excel.  I tried your solution and yes. it works!   Thank you very much.  I just need to check why it does not work if the source is sharepoint oline list.