saritta hines 9 Posted October 30, 2020 Share Posted October 30, 2020 Trying to use an OVER statement to calculate a column that is based off of the earliest date . In the below data set for ID 12, I want to show the task that is associated with the earliest date. Which would be 'Wash Dishes' for ID 12 andGo to Store for ID 14. Any help would be greatly appreciated. Task ID Date New Column Go to Store 12 5/3/2022 Do Homework 12 2/14/2021 Wash Dishes 12 1/14/2020 Wash Dishes Clean Room 12 8/19/2023 Wash Dishes 14 5/23/2021 Do Homework 14 8/19/2023 Go to Store 14 1/12/2021 Go to Store Clean Room 14 10/30/2023 Link to comment Share on other sites More sharing options...
Fabian Duerr Posted November 1, 2020 Share Posted November 1, 2020 Let's break it down... First you need the Min([Date]) over [iD]. And if this result is equal to the actual [Date] you want to return [Task]: If([Date]=Min([Date]) over ([iD]),[Task],NULL) Link to comment Share on other sites More sharing options...
saritta hines 9 Posted November 2, 2020 Author Share Posted November 2, 2020 Thank you! This worked perfectly Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now