Power BI Return Max Date

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])))
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,213,527
Messages
6,114,142
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top