Forum Discussion
Compare 3 columns
It is for a marketing assignment.
Thank you for being honest about that. Those of us who are active answering questions on this forum have a tacit agreement (many of us have talked about it in person via Teams connections) that we aren't here to do people's homework for them. So to the extent that this is a homework assignment, at the very least, we'd want to hear quite a bit more of what you've done so far to answer your own question. Then, if you've come up against a brick wall, maybe we could chip away a brick or two...
You say you have "divided column 2 and 3 to see which city orders most parcels pr. person," which is a good start. But what are your own thoughts -- not from an Excel point of view, just in terms of logic -- as to how you'd set about determining if average income has any effect?
If you can put that logic into words, you're more than half-way to your Excel answer.
(Frankly, I don't know why you'd need Power BI, unless that itself is a part of the assignment.)