Power BI Pivot Table Error

$10-30 USD

Closed

Posted

about 6 years ago

$10-30 USD

Paid on delivery

I have a power bi table I am trying to pivot but they wont work because of rows having duplicate values. The table has four rows: Store number, Date, Metric and Result. I am trying to get the metric to become columns. This should be easy for a Power Bi/Query expert and take no more than an hour to complete. I will have you login to my server and fix and logoff. If the work is satisfactory I also need to merge a few tables and create some custom dates

Business Intelligence

Project ID: 16715977

About the project

10 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

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

10 freelancers are bidding on average $26 USD for this job

@gouthamgopi

A proposal has not yet been provided

$25 USD in 1 day

0.0

(0 reviews)

0.0

@amitbdesai

Hi, I think you can convert your pivot table in SQL and then call back that table in Power BI. However, in Power BI if there is a cross table functionality then you can easily convert any table in pivot format. Please send a screen shot or any file with data in it so I can correctly advise you for how to do pivoting. Thanks

$25 USD in 3 days

0.0

(0 reviews)

0.0

@honeygoyal1109

A proposal has not yet been provided

$30 USD in 1 day

0.0

(0 reviews)

0.0

@lrgarcia

Hello okay? I understood your problem and I am a Power BI expert. I can gladly help you, I will charge a symbolic value only to be able to have you as partner of another country. Regards, Luiz Garcia

$20 USD in 1 day

0.0

(0 reviews)

0.0

@jflores00

Hello, I have worked with Microsoft technologies for more than 10 years, specially for SharePoint, in the couple of years, I have been working with Power BI and CRM. I understand the way Power BI gets the data and transform it, so once you understand your data structure and know what do you want to get from it, the rest is easy. I'm sure I can solve your error and any doubt about power bi and its connections.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@elliotparker

Afternoon, The image you sent already has the four attributes as columns. Would you like to transform another table to one looking like that? I have experience working with incredibly large data sets and complex BI stacks so I would feel quite comfortable with this task. I would greatly appreciate the opportunity.

$35 USD in 1 day