Create new Table which extracts Date/Time column from an existing table and add new columns

[Omar_204]

Hello Community,

I am new to PowerBI and currently, I am trying to create a new table using DAX query to extract only one field (Date/Time) into the table. Then I want to create new columns for month and year (based on the date/time field).

Is there a simple solution to this ?

Thank you.

Regards,

[Omar_204]

Thanks @SpartaBI .

This created a new table with exactly what I was looking for, except the month is showing as a number.

How can I make this the Month name ?

[SpartaBI]

@Omar_204 I added it in the original repsonse now. 
Please don't forget to mark that as a solution and appreciate your kudos 🙂

[SpartaBI · Accepted solution]

@Omar_204 somthing like:

Table = 
ADDCOLUMNS(
	SELECTCOLUMNS(
		SourceTable,
		"Date", SourceTable[YourDateTime Column]
	),
	"Month", MONTH([Date]),
        "Month Name", FORMAT([Date], "mmmm"),
	"Year", Year([Date])
)

Showcase Report – Contoso By SpartaBI