Hi,
I am creating a bar chart that compares 4 categories' current and previous scores. I would like the current score for each category to be a different color and all previous scores to be grey. However, I am having trouble using an IF statement since the score calculations require a set analysis. The formulas for current and previous scores are the following:
Current Score
(sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date))"}>}[Points_Earned])
/sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date))"}>}[Points_Possible]))
Previous Score
(sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date,2))"}>}[Points_Earned])
/sum({$<Evaluation_Start_Date={"$(=max(Evaluation_Start_Date,2))"}>}[Points_Possible]))
Thanks,
DJE
