Forum Discussion

d904490's avatar
d904490
Frequent Visitor
8 years ago
Solved

select the top values!

trying to select only the values which are 12 less than 160. example- name = 160, output = 160; otherwise take name whaich are less than or equal to ()160-12. I also have another table which returns ...
Need Help
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    Hi,@d904490 

        you can use this formula to add a column as like below:

    Top5 = IF(CALCULATE(MAX(Table3[current match number]))-Table2[match_number]<=5,"Top 5")

    basic data

     

    table1

     

    table2

    Then you can filter the column Top5

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

Hi,@d904490 

    you can use this formula to add a column as like below:

Top5 = IF(CALCULATE(MAX(Table3[current match number]))-Table2[match_number]<=5,"Top 5")

basic data

 

table1

 

table2

Then you can filter the column Top5

 

Best Regards,

Lin

  • d904490's avatar
    d904490
    Frequent Visitor
    7 years ago

    Thanks. It worked for me!