I need to do a calculated element for each of 300 columns. There are 300 brands in my data with rows of scores for each, and I need to work out percentages, percentiles and other calculations for each one.
Obviously I don’t want to have to manually create 300 calculated measures, so I was thinking of using a Python transform to take all the data and loop through. Problem is that I would have to create 300 placeholders.
Am I missing something? How would you do it?