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
Segment movement between two dates
Dear all, I would like to calculate the segment movement of customers between two dates, but I'dont have any idea how to model or wich dax formula to use. I have following table: The goal is to get a cross table by using following slicers: Let me explain on two customers how the desired cross table should be calculated. Customer 1: - Classified as A in 2018 - Classified as B in 2019 Customer 3: - Doesn't exist in 2018 - Classified as B in 2019 My question to you: How can I realize that? Is there already a DAX pattern (I googled it but unfortunately I couldn't find anything)? Thank you in advance. Best regards Semih
