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
