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 and so on, I need a number for each day.


thank you for now and any questions I am at your disposal

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.

     

3 Replies

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