Calculation in Power Query

[Frejo]

Hi all,

In my work I frequently work with large lists and need to verify data. Now, I've just started using Power Query to perform most of the simple, repetetive tasks. Now, I have a calculation that I do in PQ and I have kind of a solution for it but I want to have your expert opinion on how it should be done.
At the moment I calculate the steps individually in several columns using If-functions and then sum it up to get the result - It's not pretty.


What I want is to introduce 1 custom column that calculates the price per shipment the customer owes. Perhaps there is also a way of adapting to changes in prices etc. without having to resort to changing M code for the specific column?

Basically it's like this: The number of pallets x the price for the particular zone (zone is based on city) + added cost according to Rtype and RCustomercategory (Only HHH has a price)

How could this be done in a efficient way? I feel like I'm using an axe to dig with or something....


Any help on this would be greatly appreciated.


Best regards

Frej

[AliGW]

No sign of a query in the sample workbook - please share what you have already constructed.

You cannot be using Excel 2010 any longer, so please update your forum profile. Thanks.

[Frejo]

Hi Ali,

Correct there is no sign of a query in the example as I'm not looking for corrections on what I've already done, I'm looking for an example of what someone with real skills would have done with the problem I presented.
To make sure I'm not misrepresenting I've also updated my profile to reflect the current version.

[AliGW]

OK - but we are going to need mocked up results at the very least - 10-20 rows.

It would be EASIER to advise you if you shared your attempt. Without any knowledge of how you've gone about it, it's impossible to correct misapprehensions or to present an optimum solution.

Up to you. I'll wait and see if the information I've requested is forthcoming.

[Frejo]

I agree, it would be easier to have you critique my code and suggest options by attaching my code etc. - that is NOT what I'm asking for. I would like someone with more experience of M code to give me a suggestion on how to resolve the problem I've presented. In a way that is more in line with "how things are done" in the "real" world of M code. Perhaps my descriptive powers or cognitive abilities are lacking here, but that was my mission. If that does not work in this forum, please tell me and I'll close my questions.

[AliGW]

OK, if you insist - hopefully someone else has the time to build a solution for you. Sorry, but I don't have that sort of time free today.

[Frejo]

I see the error of my ways. I'll close this thread. Perhaps you as an admin can delete it? It adds zero value to the community in my eyes at least.

[AliGW]

There is no need to do that - you will just need to wait for someone who has the time to do this in the way you have asked. There are plenty of others, but most are in different time zones, so you will need to be patient.

I would have gladly had a look if you'd shared your attempt, but I just don't have time for anything more at present.