Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have the following excel.
.
I need the output as following
SlNo | Company | Date | Field | Value |
1 | Suzon | 29-11-2018 | Max unit usage | 2290.68 |
2 | Suzon | 29-11-2018 | Max unit usage % | 22.90679504 |
3 | Suzon | 29-11-2018 | Max size usage | 493.43 |
4 | Suzon | 29-11-2018 | Max size usage % | 4.93 |
5 | Suzon | 30-11-2018 | Max unit usage | 2603.84 |
6 | Suzon | 30-11-2018 | Max unit usage % | 26.04 |
7 | Suzon | 30-11-2018 | Max size usage | 491.42 |
8 | Suzon | 30-11-2018 | Max size usage % | 4.91 |
9 | Suzon | 01-12-2018 | Max unit usage | 2158.55 |
10 | Suzon | 01-12-2018 | Max unit usage % | 21.59 |
11 | Suzon | 01-12-2018 | Max size usage | 503.36 |
12 | Suzon | 01-12-2018 | Max size usage % | 5.03 |
13 | Ticson | 29-11-2018 | Max unit usage | 3624.43 |
14 | Ticson | 29-11-2018 | Max unit usage % | 36.24426464 |
15 | Ticson | 29-11-2018 | Max size usage | 3662.27 |
16 | Ticson | 29-11-2018 | Max size usage % | 36.62 |
17 | Ticson | 30-11-2018 | Max unit usage | 3612.19 |
18 | Ticson | 30-11-2018 | Max unit usage % | 36.12 |
19 | Ticson | 30-11-2018 | Max size usage | 3680.37 |
20 | Ticson | 30-11-2018 | Max size usage % | 36.80 |
21 | Ticson | 01-12-2018 | Max unit usage | 3341.74 |
22 | Ticson | 01-12-2018 | Max unit usage % | 33.42 |
23 | Ticson | 01-12-2018 | Max size usage | 3408.31 |
24 | Ticson | 01-12-2018 | Max size usage % | 34.08 |
25 | Dicche | 29-11-2018 | Max unit usage | 97.87 |
26 | Dicche | 29-11-2018 | Max unit usage % | 0.978684511 |
27 | Dicche | 29-11-2018 | Max size usage | 1417.31 |
28 | Dicche | 29-11-2018 | Max size usage % | 14.17 |
29 | Dicche | 30-11-2018 | Max unit usage | 96.72 |
30 | Dicche | 30-11-2018 | Max unit usage % | 0.97 |
31 | Dicche | 30-11-2018 | Max size usage | 1342.56 |
32 | Dicche | 30-11-2018 | Max size usage % | 13.43 |
33 | Dicche | 01-12-2018 | Max unit usage | 93.01 |
34 | Dicche | 01-12-2018 | Max unit usage % | 0.93 |
35 | Dicche | 01-12-2018 | Max size usage | 1315.61 |
36 | Dicche | 01-12-2018 | Max size usage % | 13.16 |
Could you please help me on this to achieve it in Power BI Desktop.
Thanks in advance.
Hi,
My solution here should help - Rearrange a multi heading dataset into a single heading one which is Pivot ready.
hi, @Anonymous
Do you mean that you want to transform data like your screenshot into the output you need?
If so, how do you import the data into power bi, I think your expected output should be the basic data structure.
And the screenshot should be a visual.
If the data in excel has the data model, you could use Import Excel workbooks into Power BI Desktop
Best Regards,
Lin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |