cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to get Top 5 of Yesterday only Sales by Product

Hi Team,

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

Thank you in advance

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: How to get Top 5 of Yesterday only Sales by Product

@arungurung 

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

Highlighted
Frequent Visitor

Re: How to get Top 5 of Yesterday only Sales by Product

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

Highlighted
Microsoft
Microsoft

Re: How to get Top 5 of Yesterday only Sales by Product

Hi @arungurung ,

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

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors