Complex DAX Problem! (Only freelancers with very strong DAX experience should apply)
$10-30 USD
Closed
Posted almost 4 years ago
$10-30 USD
Paid on delivery
Complex DAX Problem! (Only freelancers with very strong DAX experience should apply)
Hi,
I need some help with a DAX problem.
P.S:
I’ve +2 years with DAX, even though I couldn’t solve this problem by myself. Hence, I need someone with very strong DAX experience.
What kind of data do we have?
I need to sum up the costs of several cost center numbers in a certain way. All the numbers are recorded in one big general ledger that contains costs incurred for several products across several cost centers.
Please, find attached a sample of the data.
What’s the problem?
General and administrative costs (i.e. sales & marketing, office leasing, administration salaries ..etc) are recorded across all the products randomly. A cost allocation matrix is used to determine the proportion of each product of each cost type.
Additionally, there are operational expenses which are directly linked to each single product.
What needs to be done?
The challenge is to allocate the correct proportion of “General and administrative” costs to each product. Knowing that the company operates across USA and Canada, and there might be different cost allocation percentage for the product depending on the country it was sold at.
The column “Cost%” on the attached Excel file shows how much of the cost mentioned in the transaction should be allocated to the the product specified in the transaction.
The data would be provided to selected candidates!
This task needs to be finished by this Sunday 05/04/2020
I’m happy to explain more if required.
Hello, We have successfully delivered a lot more projects of Power Bi, hence it is very quick for us to solve the required issue under the given deadline.
Why to choose me?
As I said earlier, We are experienced and have a powerful hands on Power Bi platform.
Also we have some experts which are very much familiar with the Business Intelligence.
Also we assist your queries and can help you solving all your issues untill and unless you are satisfied with the work.
We are always ready with a good passion and energy.
So let's start working.