Forum Discussion

Helper I

4 years ago

Solved

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

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,

SpartaBI

4 years ago

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

3 Replies

SpartaBI

Community Champion

4 years ago

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

Omar_204
Helper I
4 years ago
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
  Community Champion
  4 years ago
  Omar_204 I added it in the original repsonse now.
  Please don't forget to mark that as a solution and appreciate your kudos 🙂

Forum Discussion

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

3 Replies

Related content

Extract date from date and time

DAX - Extract Date from TimeStamp (contain date & time)

Extract Data from sharepoint

Date/Time

Extract ISO 8601 Date-Time and Convert it to Date-Time-Format