Forum Discussion
Solved
get value based on dynamic column
hi all, i want to get a value from a table based on a dynamic columns name. Here is the context: my tables are linked this way: here is an example of structure info: as yo...
Minseven07 , You should unpivot the year columns in the power query
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Minseven07 , You should unpivot the year columns in the power query
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
I have tried this but i have unpivoted the years column and the id. Unpivoting just the years worked! You rock! Thanks