Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

changing date format from text to date

Hello,   I am creating a dashboard to be able to show controls that are expiring withing a certain period of time. This is my code: For this code to work with my data, the 'ITRMP Controls'[E...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Anonymous ,

     

    You need to add a custom column to convert the date to dd/mm/yyyy format in Power Query Editor. Then convert the Custom column to date type.

     

    = let mylist = Splitter.SplitTextByDelimiter("/")([Date])
in Text.Combine({mylist{1}, mylist{0},mylist{2}},"/")

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Anonymous ,

 

You need to add a custom column to convert the date to dd/mm/yyyy format in Power Query Editor. Then convert the Custom column to date type.

 

= let mylist = Splitter.SplitTextByDelimiter("/")([Date])
in Text.Combine({mylist{1}, mylist{0},mylist{2}},"/")

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you it worked!