Forum Discussion

alexandrerich's avatar
alexandrerich
Regular Visitor
4 years ago
Solved

Double data

Hi,    I want to find how many hours trailers is at my warehouse.   In my document I know when a driver come whit a trailer and when is go out whit different trailer.    In my PowerBI, I find how...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi alexandrerich ,

     

    You can use merge.

     

    1.Duplicate the main table out of a new table, then retain the ID and time of the old table, and retain the ID and time of the new one, and then merge.

     

    2.Then expand the table

     

    3.Then add custom column to calculate the difference.

     

    4.Convert the column to total hours.

     

     

     

    Best Regards,

    Stephen Tao

     

    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

Hi alexandrerich ,

 

You can use merge.

 

1.Duplicate the main table out of a new table, then retain the ID and time of the old table, and retain the ID and time of the new one, and then merge.

 

2.Then expand the table

 

3.Then add custom column to calculate the difference.

 

4.Convert the column to total hours.

 

 

 

Best Regards,

Stephen Tao

 

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

 

alexandrerich's avatar
alexandrerich
Regular Visitor
4 years ago

Thank's, is exactly what I search