Dynamic combined customer and product 8020 analysis
Hi, Im wanting to create a dynamic measure to analyse which "A" customers bought which "A" products and so on. Must be dynamic, to use the page filters I have. Analysis to spit out: 1) sum of sales for A customer purchasing A product, also AB, BA, BB, etc 2) number of customer (and products) in AA, AB, etc 3) which customers / products in AA, AB etc Data set is transaction order history, so includes customer name / code, product name / code and sale date. Can someone please help as my DAX is not at this level, assume it needs to be done in virtual tables then bringing together?
Count Customers aggregately based on their latest status change on a monthly basis
Hi guys, i have this table of customers (Contact Id) with all their status changes along their way on a monthly basis: i wish to calculate by measures the number of customers for each status for each month, which means the latest status available should be considered and calculated until next status change. once a customer has its first change, he should be calculated until current month. There is a table to present what i mean (but in columns. not measures): thanks in advance, Amit
