Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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!
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |