Forum Discussion

MClipsham92's avatar
MClipsham92
Frequent Visitor
7 years ago
Solved

Specifying a Row using two columns

Hi All,   Apologies if the title wasn't very clear I was having trouble thinking of how to word it.   I have some survey data from students from multiple points in a programme. Each survey the st...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    7 years ago

    MClipsham92 

     

    Hope I understand your requirement clearly. Thanks.

     

    Column = 
VAR a= if(Sheet3[attribute]="listening end of week 12",MAXX(FILTER(Sheet3,Sheet3[student]=EARLIER(Sheet3[student])&&Sheet3[attribute]="resilience start of programme"),Sheet3[score]))
return if(ISBLANK(a),BLANK(),if(Sheet3[score]<a,"Did not improve","Improved"))

ryan_mayu's avatar
ryan_mayu
Super User
7 years ago

MClipsham92 

 

Hope I understand your requirement clearly. Thanks.

 

Column = 
VAR a= if(Sheet3[attribute]="listening end of week 12",MAXX(FILTER(Sheet3,Sheet3[student]=EARLIER(Sheet3[student])&&Sheet3[attribute]="resilience start of programme"),Sheet3[score]))
return if(ISBLANK(a),BLANK(),if(Sheet3[score]<a,"Did not improve","Improved"))