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.

     

Sergione's avatar
Sergione
Regular Visitor
4 years ago

Hi Vitor_sp_bo, to achieve it you need to build a measure in the following way:
Measure Average = Average ( TableName[ColumnName] ).

Then you drag and drop this measure together with date columns on the canvas and will get a desired result.

If you really want to understand why it works and how, I strongly suggest you to read this artcile (link) SQLBI team are real professionals in explaining Power BI concepts.

Good luck with your Power BI journey!

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