Forum Discussion

Nandor's avatar
Nandor
Icon for Helper I rankHelper I
10 years ago
Solved

Generate a date key

Hi,   I have a classical Date&Time column in my database. I would need to add a new column generated from year, month and day.   For example: 20160905 for the 5th of september 2016.   Thank yo...
Need Help
  • grapefruitmoon's avatar
    grapefruitmoon
    10 years ago

    In Power Query/M you could use:

     

    Date.ToText([DateColumn], "yyyMMdd")

  • tjd's avatar
    tjd
    10 years ago

    Nandor -

     

    Try this: DateInt = ([Year]*10000)+([Month Nbr]*100)+[DayOfMonth])

  • Framet's avatar
    Framet
    10 years ago

    Hi,

     

    Some very valid suggestions, my personal choice would be to have the following calcualted column:

    =FORMAT ( [YourDateField], "YYYYMMDD" )

     

    Cheers

grapefruitmoon's avatar
grapefruitmoon
Icon for Advocate I rankAdvocate I
10 years ago

In Power Query/M you could use:

 

Date.ToText([DateColumn], "yyyMMdd")

  • Nandor's avatar
    Nandor
    Icon for Helper I rankHelper I
    10 years ago

    Thank you!

     

    All three solutions work perfectly.

     

    Best regards,

    N