Forum Discussion
Comparing Dates Grouping By Another Column
Example data is below. Date Item 1/5/2024 XX 1/20/2024 XX 1/20/2024 XX 1/15/2024 XY 1/20/2024 XY 1/25/2024 XY I am trying to group by Item and compare the origina...
Anonymous,
Here's a Power Query solution:
1. Group by Item and add columns Min Date and All (all rows):
2. Click the double arrow on the All column and select Date:
3. Add a custom column Delay:
Duration.Days([Date] - [Min Date])4. Result:
Anonymous,
Here's a Power Query solution:
1. Group by Item and add columns Min Date and All (all rows):
2. Click the double arrow on the All column and select Date:
3. Add a custom column Delay:
Duration.Days([Date] - [Min Date])
4. Result: