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.

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , A new column

new column =

var _cnt = countx(filter(Table, [Project Name] = Earlier([Project Name]) && isblank([Actual Finish]) ), [Project Name] )

return

if(isblank(_cnt), [Actual Finish], blank()) 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Its showing error .Syntax error.