Forum Discussion
How to scale a multi-categories / multiple vales using another table with factors
Attached is a brute force method that uses an additional index on the TABLE table.
Thanks for the answer! It's a good approach to what I need, but unfortunately it' a brute force method.
Finally I will use this solution.
I hope you are aware that what they proposed on SO is pretty much identical to my proposal. Both are brute force and may not work at larger scales.
Hi lbendlin! I think (I am a beginner with PBI) that the solution of SO does not use brute force.
That solution requires that the names of the corresponding columns in the Values and Factors tables be the same (since in my example they are not the same, SO adds an extra step by replacing the words "value" and "factor". I applied that solution to tables with numerous columns and it works, regardless of the column names, as long as the corresponding column names in the Values and Factors tables are the same.Because of that (multiple columns with unstructured names) I think the SO solution doesn't use brute force. Anyway, I appreciate your solution and the time you spent helping me.
Greetings,José
