Mihai,

To get the most recent reporting date for each project, I think you want to use a LOD calculation fixed on project.

Try:  {FIXED[Name] : MAX([Reporting Date])}

Replace the MDY(Reporting Date) pill on the row column.  Click the carrot on the pill and choose the date format you want and then make the pill discrete.

Hope that helps you get closer to the goal.

-Hope

Mihai,

I created 2 additional LOD calcs.

Project Start Date: {FIXED[Name] : MIN([Gate Planned Date])}

Project End Date: {FIXED[Name] : MAX([Gate Planned Date])}

Are those the right dates?

-Hope

Are there always 6 phases???  I"m assuming the answer is no, but it can't hurt to ask.

Ok, that was tricky but I think I found a solution.

First, go to the Data Page, Right click on the column for Project Phase and Split them.  This will put the text in one column and the number in another.

Then change the Project End Date Calc to:

{FIXED[Name] : (CASE MAX([Project Phase - Split 1]) WHEN "6" THEN

MAX([Gate Planned Date])END)}

This is still fixed on the project name, but only returns the Max End date when the Phase is 6.  In the example book you posted I got a null for Project Y because there is no Phase 6 in the data.

How's that?

Mihai,

I am not sure that you can fix a calc on 2 dimensions...maybe someone with a little more LOD experience will chime in.

Maybe it's because I haven't looked at the data in a couple days, but I'm wondering why you want to fix it on Reporting date.  I thought we created another calc to ensure we always got the most recent reporting date.

Have a good day,

Hope