Moving Target

Question

Hi All,&nbsp;I have a dummy PBIX file, where I'm trying to find out how to properly handle moving targets.&nbsp;At the daily level it does properly show because it's not aggregated, but as soon as I roll up the visual the target is already off. Is there a way to handle this behavior properly?

vvelarde · Answer

ovetteabejuela&nbsp;The Daily_Sales_Target is the Average?.&nbsp;

ovetteabejuela · Answer

Vvelarde,&nbsp;For example, for January 1st to January 10th, the target percentage of items to sell is 80%. However, on the next ten 10 days(and it's not a pattern of 10 days) the target changed to 85%.&nbsp;I'm actually trying to change the Aggregation calculation from SUM to something else like AVERAGE, but I'm not sure if this is the right thing to do. Doing some checking myself here...&nbsp;

v-huizhn-msft · Answer

Hi&nbsp;ovetteabejuela,I can't download your .pbix file, could you please share your file in here, so I download and analysis further.Best Regards,Angelia

ovetteabejuela · Answer

v-huizhn-msft, sorry I'm in a corporate network right now and OneDrive(Public) is being blocked, same reason why I published the PBIX file in Google Drive(not sure why IT did not block that one).&nbsp;When I get home, 12 hours from now. I can share it in OneDrive although I did check and it seems that the link I just shared above is working just fine.&nbsp;Thank you by the way for trying to look into this.

dog · Answer

Hi&nbsp;ovetteabejuela&nbsp;looking at&nbsp;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&nbsp;changing the aggregation from SUM to Average does appear to give the&nbsp;results in a much more meaningful manor.&nbsp;&nbsp;&nbsp;&nbsp;is this not what you were looking&nbsp;for?&nbsp;

Forum Discussion

Moving Target - How to Handle

7 Replies

Related content

moving average help

Handling Null Values

Moving Target Sum

Power BI Service Region Move