Forum Discussion

anelliaf's avatar
anelliaf
Icon for Helper II rankHelper II
6 years ago
Solved

Json Timestamp to Date

Hi,   I parsed a JSON file into a few columns in Power BI.  I have a column called 'CreationTime' that seems to be a timestamp field, i.e.:   2019-09-27T15:53:14   I'd like to break this down i...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi anelliaf 

    Please change it to "datetime" type.

     

    select "column1", then add column-> date only,

    select "date", then add column-> year/month,,,ect

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

anelliaf you can change it to date/time by clicking the column header and then add another step to change it to date. You can also add custom column and datetimezone function to get date from it.

  • anelliaf's avatar
    anelliaf
    Icon for Helper II rankHelper II
    6 years ago

    When I go to Model, click on the column 'CreationTime', and in the Properties page I choose Date under DataType I receive the following message:

     

    We can't automatically convert the column to Date type.

    • v-juanli-msft's avatar
      v-juanli-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi anelliaf 

      Please change it to "datetime" type.

       

      select "column1", then add column-> date only,

      select "date", then add column-> year/month,,,ect

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