Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculate average based on selected date

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..

 

 

 

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.