Craigc3814
Board Regular
- Joined
- Mar 7, 2016
- Messages
- 217
I have rummaged through posts but cannot get any formulas to work
I have a project table that has Project ID's (only one occurrence of each ID)
then I have a schedule table that has the same project id's but multiple occurrences for each task that a project has. Each task has what is called a baselinefinishdate
I want to lookup the max date for a given project ID from the project table on the schedule table and return the max date
I have been trying this but its telling me it needs an aggregation. I am unsure of where to add that I tried adding Max before the final project Id but no luck
Basefinish = CALCULATE(MAX(Schedule[BaselineFinishDate],FILTER(Schedule,Schedule[ProjectID] = 'Project Table'[ProjectID])))
I have a project table that has Project ID's (only one occurrence of each ID)
then I have a schedule table that has the same project id's but multiple occurrences for each task that a project has. Each task has what is called a baselinefinishdate
I want to lookup the max date for a given project ID from the project table on the schedule table and return the max date
I have been trying this but its telling me it needs an aggregation. I am unsure of where to add that I tried adding Max before the final project Id but no luck
Basefinish = CALCULATE(MAX(Schedule[BaselineFinishDate],FILTER(Schedule,Schedule[ProjectID] = 'Project Table'[ProjectID])))
