Converting Whole Number to Date/time

[Anonymous]

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, 

[Vvelarde · Accepted solution]

@Anonymous

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

[Vvelarde · Accepted solution]

@Anonymous

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

[Anonymous]

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

[Anonymous]

Sure.

[Vvelarde · Accepted solution]

@Anonymous

Hi, please check the image

Regards

Victor

Lima - Peru

[Anonymous]

Wonderful, couldn't be happier. Thanks.