Do you want to know your top purchasing customer per product? Here, I will be showing you how to utilize and combine DAX formula functions to dynamically identify the name of the highest purchasing customer.

***** Video Details *****
2:25 MAXX iterating function to create a table for determining Top Customer
2:42 TOPN to create a ranking table
3:10 SUMMARIZE to create table of all customers and all of their revenues
4:30 referencing customer name column to extract top customer
6:21 extracting top customer data from different channels
7:15 getting the revenue of the top customer per product

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

Read More

Share This