calculate highest average daily profits.

[Anonymous]

I'm trying to build a report showing highest average daily profits.  How can we visualize this for market sector and child companies? 

I wuold also like to know how should this distribution will change overtime. 

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks