Forum Discussion
Power Pivot - Dividing two columns
Hey, I have two columns (dollar discount, active customers) in a connection in power pivot in excel. I want to divide them by each other. In power pivot the calculation looks like it works correctly ...
What exactly is wrong, could you please provide bit more details? And what do you aggregate - calculated column or measure?
SergeiBaklan I think I just found a solution. I had to create it outside of powerpivot, just in the regular excel UI. powerpivot tab and then create a new measure. That way the aggregation worked correctly!