Forum Discussion

Vitor_sp_bo's avatar
Vitor_sp_bo
Helper I
4 years ago
Solved

average by day number

Guys, good afternoon! all right? I need help finding the average by date... example to follow I have a base with 1 year of data, basically I want to know the average sales on each day 1, 2, 3, 4 an...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Vitor_sp_bo ,

     

    Please try the following measure:

     

    Ave = 
AVERAGEX (
    FILTER ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] <= MAX ( 'Table'[Date] ) ),
    CALCULATE ( SUM ( 'Table'[Value] ) )
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Vitor_sp_bo's avatar
Vitor_sp_bo
Helper I
4 years ago

Thanks for the comment, that way I will only have an average value, I need 1 value per day, for example, take every day 1 (first) and see the average only of these and not a consolidated value

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Vitor_sp_bo ,

 

Please try the following measure:

 

Ave = 
AVERAGEX (
    FILTER ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] <= MAX ( 'Table'[Date] ) ),
    CALCULATE ( SUM ( 'Table'[Value] ) )
)

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.