How to get Top 5 of Yesterday only Sales by Product

[Anonymous]

Hi Team,

is there any way we can get Top 5 Product by Sales (Yesterday only sales)?

Thank you in advance

[Fowmy]

@Anonymous 

Yes possible, share some sample data and show the desired result.

[Anonymous]

I have a date slicer. Let's say date range is from 1 Jan to 10 Jan Also I have country and sales amount.

So my question is how can I get yesterday(9 JAN) best selling top 5 countries by using Dax. Any help?

I tried by using Top N filter option but unable to filter only Yesterday date based on calender slicer

[v-yiruan-msft]

Hi @Anonymous ,

You can refer the following blogs to achieve it.

Top and Bottom 10 Products by Sales Using RANKX in Power BI

Showing the top 5 products and Other row

Top 10 by Sale for each Category

If the above ones are not applicable for your scenario, please provide your sample data(exclude sensitive data) and expected result in form of table. Thank you.

Best Regards

Rena