cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Route11 Member
Member

Date Column to Table

Hi Experts

 

I have the following two columns in my table. Year and Month. so assume Year is 2018 and month is Jan, i want to add a third column that gives me that date as 01/01/2018....for each of the dates in columns Year and Month.

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Date Column to Table

Hi @Route11

How about this for your new column:

 

DateColumn = DATE(Table1[Year], Table1[Month], 1)

 

 

Super User
Super User

Re: Date Column to Table

Hi,

 

This calculated column formula should also work

 

=1*("1/"&[Month]&"/"&[Year])

 

Format this column as Date.

5 REPLIES 5
Super User
Super User

Re: Date Column to Table

Hi @Route11

How about this for your new column:

 

DateColumn = DATE(Table1[Year], Table1[Month], 1)

 

 

Route11 Member
Member

Re: Date Column to Table

many thanks AIB - spot on

Super User
Super User

Re: Date Column to Table

Hi,

 

This calculated column formula should also work

 

=1*("1/"&[Month]&"/"&[Year])

 

Format this column as Date.

Route11 Member
Member

Re: Date Column to Table

Thanks Ash

Super User
Super User

Re: Date Column to Table

You are welcome.