Power BI Return Max Date

Craigc3814

Board Regular
Joined
Mar 7, 2016
Messages
211
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])))
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,089,638
Messages
5,409,474
Members
403,265
Latest member
HMR120

This Week's Hot Topics

Top