Forum Discussion

alitzellachner's avatar
alitzellachner
Frequent Visitor
3 years ago
Solved

Datetimezone conversion

Hy, I'm new in Power BI and in this forum but currently didn't find an appropriate solution 🙂 I want to get the actual date and time (UTC) into a ISO 8601 standard text with format yyyy-mm-ddThh:m...
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    3 years ago

    Hi, alitzellachner 

     

    try using this way. 

     

    let
    CurrentDateTime = DateTimeZone.UtcNow(),
    ISOFormat = DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ")
    in
    ISOFormat

     

    DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ") formats this date and time according to the ISO 8601 format.

     

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    3 years ago

    Happy to help.