Forum Discussion

VuongLM93's avatar
VuongLM93
Icon for Helper III rankHelper III
6 years ago
Solved

Reduce Target by accumulated sales

Dear all,

I am building a Report for Sales. Which have these tables

 

Then I have dataset of "Actual" DAILY SALES , which show how many of each product each Salesperson has made over time:

 

 

My question: How to get the aggregated "Actual daily" with Targets by Month when showing "DAY" level.

And as each days go by, I would like to see the "Target per day" - Accumulated sales that has been Sold.



 

1 Reply

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Icon for Community Support rankCommunity Support

    Hi,

     

    After a lot test and research, hope this helps:

    pbix 

     

    Best Regards,

    Giotto Zhi