Forum Discussion
DAX
Dataset of customers and the services (Plans) they had bought from my company. I am working on a Cross-Selling analysis project. Based on this data, I saw the names of the customers who (for e...
one possible solution is to create a reference (or duplicate) of this table in power query. Then add unpivot step to transofrom the data to show each row representing a customer and each column representing a plan. If a plan is available the value would be 1 otherwise it will be 0. 0 also represent the cross sale opportunities.
This new table can also be linked back to the original table via data model. This obviously works better if you don't have too many products...