Forum Discussion
Table Transformation for sankey diagram
Community SupportHi krishna_sipl ,
Can you explain how each column in this table is obtained?
You may need to use DAX if you want to get this table, but I don’t know its calculation logic.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-lionel-msft
So From Table 1(1st Image):
Using Date and ascending Time on that Date, ID wise create a source and Destination
Example: If one ID has 3 names A, B, C then it will be like by date and ascending time :
Source Destination
A B
B C
also, the Same ID can repeat on a different date as well. and count repeated source and destination in Count column.
- az38
Community Champion
Hi krishna_sipl
it's completely unclear logic.
could you explain whats your final result based on your table1? how does should look like your chart?
