Forum Discussion
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...
Fixed it by removing everything after today in my OrdinalDate column (1-365)
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
Fixed it by removing everything after today in my OrdinalDate column (1-365)