Forum Discussion
Helper IHow to scale a multi-categories / multiple vales using another table with factors
Helper IHi 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é
Helper Ilbendlin you right, I founded the brute force in the table FACTORS. Thanks.
- lbendlin
Super User
here is some inspiration if you want to investigate further
Excel Matrix Multiplication - Replacing MMULT with Power Query - DataChant
It's a bit overkill but can serve as guidance.
