Show Last N Sales Of A Customer Only - Advanced DAX Technique Using TOPN Function

For this piece of analysis, we'll be reviewing an amazing technique using the TOPN function in Power BI.

There are so many great insights you can showcase when using TOPN well, especially inside an iterating function like SUMX.

Plenty to learn in this video. Good luck!

Sam


**** Video Details****
0:48 - sample report showing the last three customer sales
1:49 - calculating the last three customer sales
2:48 - using the TOPN function
3:21 - adding the SUMMARIZE function
4:09 - removing the CALCULATETABLE function
7:11 - showing the last sales by product name


**** Learning Power BI? ****
FREE COURSE – Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE – Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE – 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE – Power BI Resources - http://enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...


****Related Links****
When Did Your Customers Make Their Last Purchase - https://blog.enterprisedna.co/when-di...
Show Results Up To Current Date Or A Specific Date In Power BI - https://blog.enterprisedna.co/2019/07...
Counting Customers Over Time Using DISTINCTCOUNT - https://blog.enterprisedna.co/countin...


****Related Course Modules****
Business Analytics Series - http://portal.enterprisedna.co/p/busi...
Financial Reporting w/ Power BI - http://portal.enterprisedna.co/p/fina...
Solving Analytical Scenarios w/Power BI & DAX - http://portal.enterprisedna.co/p/solv...


****Related Forum Posts****
Show Last N Sales Of A Customer Only - Advanced DAX Technique Using TOPN - https://forum.enterprisedna.co/t/show...
Evaluating New Customer Sales - https://forum.enterprisedna.co/t/eval...
Calculating New & Existing Customer Sales - https://forum.enterprisedna.co/t/calc...
For more customer sales queries to review see here - https://forum.enterprisedna.co/search...