Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Format Text to Date

Hi,

I need your help.

Im tried to convert "2022-04-11T10:15:46Z" do date but I did not find any solution.

Could you share sample with me?

Regards

Not : Im newbie in Power 

 

Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Anonymous When I copy paste your date sample so by default PBI accepts it as Date/Time format. In case if it is Text for you so you can try this DAX in new column:

    Text to Date Column = LEFT('Date'[Date],10)

     

    Then mark this newly created column to Date from Data type option.

     

     

3 Replies

  • ribisht17's avatar
    ribisht17
    Super User
    4 years ago

    Hi,

     

    I did not have any problem in having it as a Date, please elaborate or share the file

     

     

     

    Regards,

    Ritesh

  • ribisht17's avatar
    ribisht17
    Super User
    4 years ago

    Please mark it as close if your problem is solved or you can provide your solution.

     

    Regards,

    Ritesh

  • Tahreem24's avatar
    Tahreem24
    Super User
    4 years ago

    Anonymous When I copy paste your date sample so by default PBI accepts it as Date/Time format. In case if it is Text for you so you can try this DAX in new column:

    Text to Date Column = LEFT('Date'[Date],10)

     

    Then mark this newly created column to Date from Data type option.