Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with Matrix table for Dates

Hi   Below is the sample table that I am using. I want to populate a roll up data using Matrix table or table for the no of projects from sharepoint list Project Name Task Name Planned Start ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    Anonymous 

    Looks like 4 measures

    Min Planned Start = MIN ('Table'[Planned Start] )
    Max Planned Finish = MAX ('Table'[Planned Finish] )
    Min Actual Start = MIN ('Table'[Actual Start] )
    Max Actual Finish = 
VAR _Blanks = CALCULATE ( COUNTROWS ('Table'), ISBLANK ( 'Table'[Actual Finish] ) )
RETURN 
IF ( _Blanks = 0, MAX ('Table'[Actual Finish] ), BLANK() )

    You can change the names of the measures in the table to remove the Min and Max if you want.

     

     

jdbuchanan71's avatar
jdbuchanan71
Super User
4 years ago

Anonymous 

Looks like 4 measures

Min Planned Start = MIN ('Table'[Planned Start] )
Max Planned Finish = MAX ('Table'[Planned Finish] )
Min Actual Start = MIN ('Table'[Actual Start] )
Max Actual Finish = 
VAR _Blanks = CALCULATE ( COUNTROWS ('Table'), ISBLANK ( 'Table'[Actual Finish] ) )
RETURN 
IF ( _Blanks = 0, MAX ('Table'[Actual Finish] ), BLANK() )

You can change the names of the measures in the table to remove the Min and Max if you want.