Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
i have a table like this and i need to create a new two colum to have the date start and date end (min and max) for each order (ordine di produzione).
For example order 5650734146 must be have start date at 03/01/2024 18:50 and finish date at 04/01/2024 03:15.
ORDER | START | END |
5650734146 | 03/01/2024 18:50 | 03/01/2024 20:15 |
5650789756 | 02/01/2024 19:25 | 02/01/2024 20:35 |
5650734146 | 03/01/2024 23:33 | 04/01/2024 03:15 |
5680987844 | 30/01/2024 23:33 | 30/01/2024 23:53 |
This is an example and this is my file https://docs.google.com/spreadsheets/d/1r6UTQPQ-OUUUFM4LO9OtHfZwSHcNnIUyulhNorJbE7M/edit?usp=sharing
Solved! Go to Solution.
Hi @lifesafari
I create a table new dates with your sample :
Hi @lifesafari
I create a table new dates with your sample :
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |