Hi Team,is there any way we can get Top 5 Product by Sales (Yesterday only sales)?Thank you in advance
@arungurung Yes possible, share some sample data and show the desired result.
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
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.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.