Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Good afternoon people. I have a table of this type
Shipment N | Tool | Date |
9459 | A | 15/08/2023 |
9459 | B | 15/08/2023 |
9459 | C | 15/08/2023 |
9435 | A | 03/08/2023 |
9435 | C | 03/08/2023 |
9435 | D | 03/08/2023 |
9435 | E | 03/08/2023 |
9435 | F | 03/08/2023 |
9434 | D | 02/08/2023 |
9434 | F | 02/08/2023 |
9410 | A | 12/07/2023 |
9410 | D | 12/07/2023 |
9410 | R | 12/07/2023 |
I need your help. I want to add a column with the previous shipment date and another one with the previous shipment number.
Shipment N | Tool | Date | Previus Date Ship | Previus Ship |
9459 | A | 15/08/2023 | 03/08/2023 | 9435 |
9459 | B | 15/08/2023 | - | - |
9459 | C | 15/08/2023 | 03/08/2023 | 9435 |
9435 | A | 03/08/2023 | 12/07/2023 | 9410 |
9435 | C | 03/08/2023 | - | - |
9435 | D | 03/08/2023 | 02/08/2023 | 9434 |
9435 | E | 03/08/2023 | - | - |
9435 | F | 03/08/2023 | 02/08/2023 | 9434 |
9434 | D | 02/08/2023 | 12/07/2023 | 9410 |
9434 | F | 02/08/2023 | - | - |
9410 | A | 12/07/2023 | - | - |
9410 | D | 12/07/2023 | - | - |
9410 | R | 12/07/2023 | - | - |
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
18 | |
15 | |
7 | |
5 |