Measure to display the "Personnel" last "Days to Close" based on the current Date filter

[Masikonde]

Hello Experts,

I’m trying to build a measure that will extract the last "Days to Close" from the "Personnel_contract_tracker" based on the latest date in the tracker. in this case "Days to close" is the average days it took for the contract team member to close on a contract. The measure should be able to select the team member, the last month or date and return the value of “Days to Close”

Below is a sample of the Personnel_Contracts_Tracker as I receive it.

[v-chuncz-msft · Accepted solution]

@Masikonde ,

You may try the TOPN Function.

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