Forum Discussion

xadya's avatar
xadya
Frequent Visitor
8 years ago
Solved

Twitter datetype to Power BI date type

Hey,   I have Twitter date that have a specific Twitter format for date: Sun Oct 15 15:55:29 +0000 2017   I would like this to be: 15 10 2017  or any workable variation on this. ...
Need Help
  • ChandeepChhabra's avatar
    ChandeepChhabra
    8 years ago

    xadya I am assuming the format of twitter dates doesn't change at all

     

    1. Using powerquery extract the year and the date
    2. Create a separate Months table with Month Name and Month Index (1-12)
    3. Then write a calculated column to combine all 3 (year, month, date) into a single date

    Here is the output

     

     

    You can download the PowerBI

ChandeepChhabra's avatar
ChandeepChhabra
Icon for Impactful Individual rankImpactful Individual
8 years ago

xadya I am assuming the format of twitter dates doesn't change at all

 

  1. Using powerquery extract the year and the date
  2. Create a separate Months table with Month Name and Month Index (1-12)
  3. Then write a calculated column to combine all 3 (year, month, date) into a single date

Here is the output

 

 

You can download the PowerBI

xadya's avatar
xadya
Frequent Visitor
8 years ago

This works like a charm. Thank you so much!