RANK IF

[chethan]

Hi

I need to create the rank function based on the below example

Example:

IF A Value is >

AND IF B Value is <

AND IF C Value is >

AND IF D Value is <

Based on the above Values & condition I want to create the Rank with top 10 ... please help

[v-ljerr-msft]

Hi @chethan,

I'm wondering if you could use the formula below to create a new calculate column "E" in your table first, then use rank function based on the column "E" to get your expected result in this scenario? 

E = A*1000-B*100+C*10-D

Regards

[bsas]

Hi,

Please wath this tutorial: https://www.youtube.com/watch?v=S7eMccO1_bE

[chethan]

Its based on One Value

[chethan]

@v-jiascu-msft @Datatouille@TomMartens@MattAllington please help me on the above