Forum Discussion

BeemsC's avatar
BeemsC
Icon for Resolver III rankResolver III
9 years ago
Solved

Dial Gauge problem

Hello experts, I have an interesting problem. For my sales dashboard i need to make an actual target in the custom visual ''Dial Gauge''. The database looks like this: The filter and Di...
Need Help
  • BeemsC's avatar
    BeemsC
    9 years ago

    Fixed it by removing everything after today in my OrdinalDate column (1-365)

BeemsC's avatar
BeemsC
Icon for Resolver III rankResolver III
9 years ago

I had an idea:
I use the following formula:

Target new = DISTINCTCOUNT(DIM_DATUM[DAY_OF_YEAR]) * [Prognmargin_Amount_1day_mes]


Is it possible to say the day of year cant exceed the current day of year. So in this case like 270 or something.
I already have a formula which calculates current day ..

Thanks in advance !

 

  • BeemsC's avatar
    BeemsC
    Icon for Resolver III rankResolver III
    9 years ago

    I've tried the following:

    Target = IF(DISTINCTCOUNT(DIM_DATUM[DAY_OF_YEAR]) < [Current day];DISTINCTCOUNT(DIM_DATUM[DAY_OF_YEAR]) * [Progn_Amount_1day_mes])

    But it doesn't work, because when i go in the 10th month now, target goes to 0

     

    • BeemsC's avatar
      BeemsC
      Icon for Resolver III rankResolver III
      9 years ago

      Fixed it by removing everything after today in my OrdinalDate column (1-365)