Sankey DAX Programming

[Anonymous]

I am trying to follow the source of what Class an FR had on their first year and I am trying to trace it through the next five years in a Sankey. 

For example, FR#213 started in Class A in the first year, but then had Class C their second year, then Class A their third year, then Class D their fourth year, then Class A their fifth year. 

I was trying to do a switch true statement for the value that this visual requires, but ran into some number format issue with True/False. 

Please see the image. Thank you for helping solve this and your contribution to the community!!!

All Reps  Year Year2 Year3 Year4Year5Class

FR#213	213	31	213	321	213	A
FR#219	219	431	321	431	431	B
FR#321	321	213	219	31	321	C
FR#431	431	321	431	213	31	D
FR#031	31	219	31	219	219	E

[lbendlin]

"For example, FR#213 started in Class A in the first year, but then had Class C their second year, then Class A their third year, then Class D their fourth year, then Class A their fifth year. "

Please create a data table that reflects this statement. Your data table seems to have some reverse lookup logic that is really hard to follw, and not conducive for a Sankey. Once you place the data in the right format the Sankey will solve itself.