Average based on date slicer

[Mars3442]

Hi all,

I have created a table like this

Sales table

I created a date slicer 

And I want to create a card that would show the average based on the selected period

So,

When I select Jan, Feb, and March in the slicer

Sales Jan = 100 + 200 + 500 = 800

Sales Feb = 150 + 200 + 400 = 750

Sales March = 300 + 160 + 450 = 910

I want the card showing the average sales for 3 months = (800+750+910)/3 = 820

When I select Jan, Feb, and March in the slicer

Sales Jan = 100 + 200 + 500 = 800

Sales Feb = 150 + 200 + 400 = 750

Sales March = 300 + 160 + 450 = 910

Sales April= 220+ 210 + 500 = 930

I want the card showing the average sales for 4 months = (800+750+910+930)/4 = 847,5

Please help me to solve this problem

Thank you..

[Dangar332 · Accepted solution]

hi, @Mars3442 

Try below code 

adjust your table name

result =

var a = SUM('Table'[sales])

var b =CALCULATE(DISTINCTCOUNT('Table'[date]))

return DIVIDE(a,b)

[Mars3442]

Hi, @Dangar332 

Thanks a ton! Works perfectly!

[Dangar332]

Hi, @Mars3442 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly. Appreciate your kudos