Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I need help to create a table to show sales and ranking for current and last year.
Somehting like below:
Company | 2017 Sales | 2017 Ranking | 2016 Sales | 2016 Ranking |
A | $30 | 1 | $28 | 1 |
B | $28 | 2 | $20 | 5 |
C | $25 | 3 | $27 | 2 |
D | $22 | 4 | $21 | 4 |
E | $17 | 5 | $23 | 3 |
I can do the current year, but not sure how to include last year's sales and ranking to ONE table.
Thanks in advance.
Solved! Go to Solution.
Hi,
Open PowerBI desktop and go to File > Import > Excel Workbook contents.
Sample file can be downloaded from:
https://www.sendspace.com/file/hjs9dw
Desired result from the sample file:
2016 Sales | 2016 Ranked | 2017 Sales | 2017 Ranked | |
A | 120 | 3 | 216 | 1 |
B | 144 | 2 | 144 | 3 |
C | 180 | 1 | 192 | 2 |
Thanks for helping.
Hi,
You may refer to my solution in this workbook.
Hope this helps.
Thanks.
I know how to do it in Excel, but not in Power BI.
Hi,
Open PowerBI desktop and go to File > Import > Excel Workbook contents.
Hi,
Share the link from where i can download your file.
HI @Anonymous
Is the table in your post an example of your source table? or more what you would like to produce?
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |