Forum Discussion
Calculate Average from Top 10 Rows
Hi , We are working on Power BI reports for a client with below requirement: Requirement: We want to add a reference line in a bar chart below which is calculated as: Average of TOP 10 weeks i...
Hi eagerBI
Since I don't know your data model, I can only provide a general solution, If you have further more question about implementing in your scenario, please show me some example data and expected result.
For step2, you can follow the article
Dynamic TopN & Ranking in Power BI
For step3, please note that a new table can be dynamic based on a slicer.
For step4, Reference here
Best Reagrds
Maggie
Maggie