topic Average based on date slicer in DAX Commands and Tips

Average based on date slicer

Mars3442 — Mon, 16 Oct 2023 09:33:38 GMT

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 — Mon, 16 Oct 2023 09:56:08 GMT

Try below code

adjust your table name

result =

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

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

return DIVIDE(a,b)

Mars3442 — Tue, 17 Oct 2023 02:29:44 GMT

Thanks a ton! Works perfectly!

Dangar332 — Tue, 17 Oct 2023 03:01:48 GMT

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