Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Unable to date formatting using Direct Query

I'm having this problem when importing my data using direct query: In the Power Query my data is shown in the the right format (DD/MM/YYYY) But when I place this column inside a visual that's...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Anonymous ,

     

    Here are the steps you can follow：

    1. You can Add Column – Custom Column in Power Query Editor.

     

    Text.From(Date.Day([Date]))&"/"&Text.From(Date.Month([Date]))&"/"&Text.From(Date.Year([Date]))

     

    2. Or use the custom format.

     

     

    Best Regards,

    Liu Yang

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

vicky_'s avatar
vicky_
Super User
3 years ago

Click the Date column and then Format.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Yeah, I tried something like that, but the thing is using Direct Query mode you're not allowed to execute such thing, hence my question.

    • ppm1's avatar
      ppm1
      Solution Sage
      3 years ago

      Changing data types in the query editor is different than just changing the format string as vicky_ suggested. Did changing the format string not work?

       

      Pat