Forum Discussion
Moving Target - How to Handle
Hi All, I have a dummy PBIX file, where I'm trying to find out how to properly handle moving targets. At the daily level it does properly show because it's not aggregated, but as soon as I ro...
looking at the data, the target sales is the same across all employees, departments and dates so I would imagine that Average is the best fit. just changing the aggregation from SUM to Average does appear to give the results in a much more meaningful manor.
is this not what you were looking for?
Yes the target should be the same for everyone for a given time (start/end date).
Hi,
not entirely sure I follow, using average and drill up and down works best with a different graph as you don't have dates to use for the trend that a line graph works best with.