Forum Discussion

Alph4's avatar
Alph4
Frequent Visitor
3 years ago
Solved

HELP CONDITIONAL DATA LABEL

Good Morning ! Guys all right? I wanted to clear a doubt: Indicators with blue color is the baseline cumulative, Green color is the realized cumulative and orange is the projected cumulative. However...
DAX
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Alph4,

    What type of effects are you means? Hide specific range data line on chart or exclude the calculation of previous date ranges?

    If you mean the first one, you can add if statement to check the current date and prevent the formula calculate on not wanted ranges.

    For the second one, You can modify the formula to add the start date filter into the expression, and it will exclude the previous range calculation in your formula.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Alph4,

What type of effects are you means? Hide specific range data line on chart or exclude the calculation of previous date ranges?

If you mean the first one, you can add if statement to check the current date and prevent the formula calculate on not wanted ranges.

For the second one, You can modify the formula to add the start date filter into the expression, and it will exclude the previous range calculation in your formula.

Regards,

Xiaoxin Sheng