Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change date format in DIRECT Query Mode - not on list of selectable formats

Hi,    I would like to use the format dd/MM/yyyy HH:mm for my datetime column in DirectQuery mode. This format is not on the list of available datetime formats.    Using a calculated column with ...
Need Help
  • Icey's avatar
    Icey
    7 years ago

    Hi Anonymous ,

    You can change DateTime type in Power Query Editor.

    = Text.From(Date.Day([SalesDate]))&"/"&Text.From(Date.Month([SalesDate]))&"/"&Text.From(Date.Year([SalesDate]))&" "&Text.From(Time.Hour([SalesDate]))&":"&Text.PadStart(Text.From(Time.Minute([SalesDate])),2,"0")

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

You can change DateTime type in Power Query Editor.

= Text.From(Date.Day([SalesDate]))&"/"&Text.From(Date.Month([SalesDate]))&"/"&Text.From(Date.Year([SalesDate]))&" "&Text.From(Time.Hour([SalesDate]))&":"&Text.PadStart(Text.From(Time.Minute([SalesDate])),2,"0")

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

ToddFischer's avatar
ToddFischer
New Member
4 years ago

how to I ge tot power query editor if I do not have the ability to get into the table?