Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
AlB
Super User
Super User

Hi @Anonymous

How about this for your new column:

 

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

 

 

View solution in original post

Ashish_Mathur
Super User
Super User

Hi,

 

This calculated column formula should also work

 

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

 

Format this column as Date.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

 

This calculated column formula should also work

 

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

 

Format this column as Date.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Thanks Ash

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
AlB
Super User
Super User

Hi @Anonymous

How about this for your new column:

 

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

 

 

Anonymous
Not applicable

many thanks AIB - spot on

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.