average by day number

[Vitor_sp_bo]

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

[Sergione]

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]

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 · Accepted solution]

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.