Direct Query and Excel (import) filter/retrieve

[martijnth]

Dear Reader,

trying to build Direct Query report since it can refresh automatically. Now I have one Direct SQL and an Excel file. In the SQL i have 2 collumns ' Equipement'  and ' Produced on' in the Excel I have one (linked collumn, many to one) 'names'. 

First I want to filter in Equipement from 1to 10 then find the last product from this machine (maxx(produced on)) and return the name from excel (related) to this last build. I've tried literaly everyting with lookup and calculate but not make any progress, all help is appreciated.

reg martijn

[v-chuncz-msft · Accepted solution]

@martijnth,

You may try the TOPN Function.

https://community.powerbi.com/t5/Desktop/Card-Help/td-p/514770