Forum Discussion
IF between 2 tables
Hi there, I'm struggling with an IF statement. I have 3 tables: Actve, Ratings2016, Ratings2017. The two ratings tables have a relationship to the Active table using the employee ID with no dupli...
Wow. I think I figured this out on my own after all of these hours. It seems to work! Woohoo!! I'm so proud of myself :) :) :) :)
Column = IF (
Calculate ( Count ('Ratings2016'[Overall Performance Rating]),'Ratings2016'[Overall Performance Rating] >= 2.5) &&
Calculate ( Count ('Ratings2017'[Overall Performance Rating]),'Ratings2017'[Overall Performance Rating] >= 2.5), "HiPo",
"Not a HiPo"
)
Not sure why the 2.5 is in ""s?
Usually it needs to be. I tried without, but still no luck.