Forum Discussion
Helper ITop Sales Day, Week, Month, Year
Looking for a way to show the Top sales Day, Week, Month, and Year from sales data. This will be based off the SubmitDate from the ecommOrders table. Ive got the basics for Dax but this is a bit outside my wheelhouse. Any help would be greatly appreciated. Thank you.
Hi JChouris
You can refer to the following ways:
1.You can use TopN filter in visual filter:
you can refer to the following link:
TOP N Filter in Power BI with Zero DAX Code; Visual Level Filter - RADACAD
2.You can use TopN() function:
you can refer to the following link:
TOPN function (DAX) - DAX | Microsoft Learn
If the following information cannot work, can you provide some sample data or pbix file?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi JChouris
You can refer to the following ways:
1.You can use TopN filter in visual filter:
you can refer to the following link:
TOP N Filter in Power BI with Zero DAX Code; Visual Level Filter - RADACAD
2.You can use TopN() function:
you can refer to the following link:
TOPN function (DAX) - DAX | Microsoft Learn
If the following information cannot work, can you provide some sample data or pbix file?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Ashish_Mathur
Super User
Hi,
Share some data in a format the cal be pasted in an MS Excel file. Show the expected result as well.
