Forum Discussion

MClipsham92's avatar
MClipsham92
Frequent Visitor
7 years ago
Solved

IF statement with variable not working as expected

Hello All,   I have this code:  Overall Score Improved Term 2 = VAR a= IF('Link Teacher'[Attribute]="Link Teacher Score 3",MAXX(FILTER('Link Teacher','Link Teacher'[Identifier]=EARLIER('Link Teach...
Need Help
  • MClipsham92's avatar
    MClipsham92
    7 years ago

    Think I've worked it out, I had the scores classified as Text data type rather than whole number for some reason.

     

    Thanks,

     

    Mark.

MClipsham92's avatar
MClipsham92
Frequent Visitor
7 years ago

Think I've worked it out, I had the scores classified as Text data type rather than whole number for some reason.

 

Thanks,

 

Mark.