Comparing 2 companies profile but not able to compare Rank of companies.

[dakshayaniswami]

Hello,

Comparing revenue of 2 Companies but not able to compare rank of 2 companies.

Please help me out. File Link -  https://github.com/daksh0444/My-work/commit/038a2e2e7e01f9dcfebae942a52832810adbbf14 

Expected Result should be like this.

	Ranking of Companies
Company	2018H1	2018H2	2019H1	2019H2
Adobe	7	8	8	9
Apple	2	2	2	2

Thank You !

Dakshayani

[amitchandak]

@dakshayaniswami , You can use offset function or window (as that can be used to sort on the measure)

refer

Learn Power BI: DAX- Window and Index as Offset?- https://youtu.be/cDs9xcy0U5c

[dakshayaniswami]

Hey @amitchandak 

Can you please help me with this functions. I am new to power bi,

i am not able to find the solution.

Thank you

Dakshayani