Forum Discussion

Javyellow's avatar
Javyellow
New Member
4 years ago
Solved

How to transform data in date time differences columm

Hi, I'm new but with a difficult question.  How can I get from this:  Time Process Message 25/01/2022 03:00:35 p. m. PO PreProcess PO PreProcess execution started 25/01/2022 03:00:43 p...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Javyellow 

     

    Refer to the attached PBIX file.  There are a few steps that I've put together in Power Query.  You can follow them by looking at the Applied Steps pane or you can simply use the attached as the basis.

     

    Your output will be as follows:

     

    Hope this helps! 🙂

    Theo

     

TheoC's avatar
TheoC
Community Champion
4 years ago

Hi Javyellow 

 

Refer to the attached PBIX file.  There are a few steps that I've put together in Power Query.  You can follow them by looking at the Applied Steps pane or you can simply use the attached as the basis.

 

Your output will be as follows:

 

Hope this helps! 🙂

Theo