Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Logic for Implementing Traffic Light

Hello All,   One query here on DAX logic to be used.   I'm trying to implement a traffic light logic to show Red/Green depending on whether the target is achieved or not.    I have simplified t...
kentyler's avatar
kentyler
Solution Sage
6 years ago

So target for a given year is 500 - total sales for previous years / number of remaining years

target for a given category is target for that year/number of categories

Is that the logic you want ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes, that's right.

    Thanks.