Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
Every day I get a report that contains list of materials and updated delivery date of these materials (see table below)
Item# is unique number for each material
Arrival Date: Is the date when the item will arrive to warehouse.
Update File Date: The date of the Update file.
Arrival Date Change: This is a column that I would like to add where I show the change in delivery date. It will subtract the arrival date - in previous update file - from the latest arrival date -in the latest update file-.
Latest Arrival Date Change: This captures the arrival date from the Latest update file.
Just two notes here:
1) Looking at item # 82012969. The item is not present in 2022-09-06 file. Hence, the latest date would be 2022-09-05 and it will compare it with previous file update.
2) Looking at the same item # 82012969 (and others). The updates don't come daily. You can see update file on 2022-09-05 and the previous one is on 2022-09-02
Item# | Arrival Date | Update File Date | Arrival Date Change (days) | Latest Arrival Date |
30221296 | 2022-09-13 | 2022-09-06 | 0 | 2022-09-13 |
30221296 | 2022-09-13 | 2022-09-02 | 0 | 2022-09-13 |
30221296 | 2022-09-13 | 2022-08-31 | 0 | 2022-09-13 |
30221296 | 2022-09-13 | 2022-08-30 | 0 | 2022-09-13 |
30221296 | 2022-09-13 | 2022-08-29 | 0 | 2022-09-13 |
72709067 | 2022-09-21 | 2022-09-02 | 0 | 2022-09-21 |
82012969 | 2022-10-01 | 2022-09-05 | 1 | 2022-10-01 |
82012969 | 2022-09-30 | 2022-09-02 | 1 | 2022-10-01 |
82012969 | 2022-09-30 | 2022-08-31 | 1 | 2022-10-01 |
82012969 | 2022-09-30 | 2022-08-30 | 1 | 2022-10-01 |
82012969 | 2022-09-30 | 2022-08-29 | 1 | 2022-10-01 |
82013414 | 2022-10-03 | 2022-09-06 | 17 | 2022-10-03 |
82013414 | 2022-09-16 | 2022-09-02 | 17 | 2022-10-03 |
82013414 | 2022-09-16 | 2022-08-29 | 17 | 2022-10-03 |
Solved! Go to Solution.
@Anonymous ,based on what I got
two new columns
Lastest arrival date = maxx(filter(Table, [Item #] = earlier([Item #]) ) , [Arrival Date])
Diff = datediff([Arrival Date], [Lastest arrival date], day)
@Anonymous ,based on what I got
two new columns
Lastest arrival date = maxx(filter(Table, [Item #] = earlier([Item #]) ) , [Arrival Date])
Diff = datediff([Arrival Date], [Lastest arrival date], day)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |