Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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? 🙂
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |