Forum Discussion

chrismcdonald's avatar
chrismcdonald
Icon for Helper I rankHelper I
6 years ago
Solved

Dates rolled up to Project level

Hello,   I am looking for help again please.   I am trying to create a view table that shows a roll up of dates to a project level for the Construction Complete activity   Example Data Proj...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi chrismcdonald ,

     

    Is the following image your expected result?

    You need to edit the measure "Actual1".

    Actual1 =
IF (
    CALCULATE (
        COUNTBLANK ( 'Table'[Actual] ),
        ALLEXCEPT ( 'Table', 'Table'[Project #] )
    ) > 0,
    BLANK (),
    CALCULATE ( MAX ( 'Table'[Actual] ), ALLEXCEPT ( 'Table', 'Table'[Project #] ) )
)

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi chrismcdonald ,

 

Is the following image your expected result?

You need to edit the measure "Actual1".

Actual1 =
IF (
    CALCULATE (
        COUNTBLANK ( 'Table'[Actual] ),
        ALLEXCEPT ( 'Table', 'Table'[Project #] )
    ) > 0,
    BLANK (),
    CALCULATE ( MAX ( 'Table'[Actual] ), ALLEXCEPT ( 'Table', 'Table'[Project #] ) )
)

 

chrismcdonald's avatar
chrismcdonald
Icon for Helper I rankHelper I
6 years ago

That is perfect.. Thank you so much for your assistance.

 

I had been googling this one for days and couldn't find the solution.

 

Thank you again.!!