Find Jobs
Hire Freelancers

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.
Project ID: 24740784

About the project

6 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $48 USD for this job
User Avatar
Hi I am dasharatha from India. You can send me your detail of spreed sheet completely I Helped you.
$20 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm a well trained accountancy with 5 years experience given me the room to see my self as Mr perfect for this job.
$45 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$28 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Extensive knowledge in DAX and Power BI reporting tool with 100% customer satisfaction. I will all documents for future reference.
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello I'm Microsoft power BI certified. I can assure you that I'm able to help you. let's discuss private
$139 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of EGYPT
Giza, Egypt
5.0
2
Payment method verified
Member since May 18, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.