Forum Discussion

Mars3442's avatar
Mars3442
Icon for Helper I rankHelper I
3 years ago
Solved

Average based on date slicer

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

  • 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)
     

     

3 Replies

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar

    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)
     

     

      • Dangar332's avatar
        Dangar332
        Icon for Resident Rockstar rankResident Rockstar

        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