Forum Discussion

markmess77's avatar
markmess77
Icon for Resolver I rankResolver I
5 years ago
Solved

Way to convert integer to datetime with DAX?

I'm looking to convert my DateKey to a datetime datatype for a calculation. My DateKey is in yyyymmdd format and is stored as an integer. So for example, if I had a value of 20200701, I would want i...
Need Help
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    markmess77 


    New Column = CONVERT(COMBINEVALUES("/",LEFT([DATE KEY],4),MID([DATE KEY],5,2),RIGHT([DATE KEY],2)),DATETIME)

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi , markmess77 

You also can try to create a  custom column in Power Query Editor.

=Date.From(Text.From([Column1], "en-US"))

Please refer to the sample file for more details.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.