Calculate average based on selected date

Anonymous · ‎03-09-2021

Hi Experts

How could in calculate the Average Target for a particular date in any month. Assume the following

Jan 1st to Jan 31st my Target is 1000 every days hence Average is 1000. What ever day I select in January from my date slicer.

If for February now my target is 1500 every days... hence Average for month is 1500..

I want the Average so show as 1500 when 2nd Feb is selected and likewise when 3 Jan is selected 1000..

Ashish_Mathur · ‎03-09-2021

Hi,

Share data that can be pasted in an MS Excel file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Anonymous · ‎03-10-2021

Hi Ash, solved the issue to hand - just added the column Target and selected Average from the field and it works fine...

Thanks for looking at my question.

Helpful resources