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

Converting Whole Number to Date/time

Hi, 

 

I am dealing with a data source that has 3 columns of Year, Month, Day, Hour and they are all Data Type: Whole Number. Is there a DAX method to create a Calculated Column to combine them all into a single Data/Time data type? 

 

Thank You, 

2 ACCEPTED SOLUTIONS
Vvelarde
Community Champion
Community Champion

@Anonymous

 

Hi, Can i give you a way in Query Editor?




Lima - Peru

View solution in original post

@Anonymous

 

Hi, please check the image

 

Whl.gif

 

Regards

 

Victor

Lima - Peru




Lima - Peru

View solution in original post

5 REPLIES 5
Vvelarde
Community Champion
Community Champion

@Anonymous

 

Hi, Can i give you a way in Query Editor?




Lima - Peru
Anonymous
Not applicable

Sure, I was actually trying to solve it with Query Editor. 

Anonymous
Not applicable

Sure.

@Anonymous

 

Hi, please check the image

 

Whl.gif

 

Regards

 

Victor

Lima - Peru




Lima - Peru
Anonymous
Not applicable

Wonderful, couldn't be happier. Thanks. 

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.