Forum Discussion
Clustering Transfert Matrix
Hello,
I am trying to do a transfert matrix, to see the movements of my clients between two dates of segmentation.
My data look like this (CLIENT is a client id)
and i want to achieve this
I was able to do it on power Querry by pivoting but I would like to be able to select the two dates I want with a slicer so I need to obtain this with a dax measure. The dataset is large (30M rows) and I have 10 differents clusters.
Anyone has an idea please ?
1 Reply
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
