Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pBur
Frequent Visitor

Transforming Data - Profit-Loss report

Hi everybody, I am quite new at this, however I hope someone could direct me to the right path for solving a little issue. I have a profit/loss report on my hand and I need to get the data in shape for PowerBI Currently the report is not BI friendly and the formatting of the data goes like this in excel file:

 

Figures USD)                                        01|            02| CompanyID

Net Sales                                  1,500,000| 2,000,000| XXX

Cost of Sales                               350,000|   375,000| XXX

Gross Income                           1,150,000| 1,625,000| XXX

Operating Expenses (SG&A)       235,000|   260,000| XXX

Operating Income                      915,000| 1,365,000| XXX

Other Income (Expense)               40,000|     60,000| XXX

Extraordinary Gain (Loss) -           15,000|      20,000| XXX

...........................

 

So I have income/expense types in the rows and month numbers in the column headers. So far it's just causing me a headache. Are there any simple way of getting the data in shape? I am hoping to see something like this in the result:

 

Net Sales | Cost of Sales | Gross Income | Date/Month | CompanyID

1,500,000 |          350,000|       1,150,000 |                 01 |              XXX

2,000,000 |          375,000|       1,625,000 |                 02 |              XXX

 

Maybe anyone has encountered such challenges and could share the best practice to solve it? 🙂

 

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@pBur

 

i made a video to show a way to do it this:

 

 

The audio es really bad but following the steps you can do it.

 




Lima - Peru

View solution in original post

2 REPLIES 2
Vvelarde
Community Champion
Community Champion

@pBur

 

i made a video to show a way to do it this:

 

 

The audio es really bad but following the steps you can do it.

 




Lima - Peru
pBur
Frequent Visitor

hi, Thanks for the video!!! Challenge solved 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.