Shows multiple rankings in one table

[Anonymous]

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.

[Anonymous]

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.

[Ashish_Mathur]

Hi,

You may refer to my solution in this workbook.

Hope this helps.

[Anonymous]

Thanks. 

I know how to do it in Excel, but not in Power BI.

[Ashish_Mathur · Accepted solution]

Hi,

Open PowerBI desktop and go to File > Import > Excel Workbook contents.

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.

[Phil_Seamark]

HI @Anonymous

Is the table in your post an example of your source table?  or more what you would like to produce?