Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Experts,
I want to convert the date format of "created_at" from twitter API to the format as "%Y-%m-%d %H:%M:%S", throuth Python or other ways.
I've downloaded Python and can use it on Power Query of BI.
Sorry for not knowing exact script of Python on BI, could you please kindly tell me the script?
Best regards.
Solved! Go to Solution.
@Anonymous
I added a custom column in PQ to convert the given date-time to the desired format. Please check the attached file. You can do further formatting in Power BI once you load the table to the model.
let
m = Text.Middle([Column1],4,3),
d = Text.Middle([Column1],8,2),
y = Text.End([Column1],4),
t= Text.Middle([Column1],11,8)
in
DateTime.FromText ( y &"-"& m &"-"& d &" "& t
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you for your quick reply!
It is the example of the date format of "created_at" column and the date format that I want to convert.
from
Wed Jun 30 14:54:36 +0000 2021
to
2021-6-30 14:54:36
Best regards,
@Anonymous
I added a custom column in PQ to convert the given date-time to the desired format. Please check the attached file. You can do further formatting in Power BI once you load the table to the model.
let
m = Text.Middle([Column1],4,3),
d = Text.Middle([Column1],8,2),
y = Text.End([Column1],4),
t= Text.Middle([Column1],11,8)
in
DateTime.FromText ( y &"-"& m &"-"& d &" "& t
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Dear Fowmy
It works!!
I really appreciate your help!
@Anonymous
Can you share some sample dates for "Created Date"? This can be done using M in PQ
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group