count/ countif/ calculate/ filter

[Anonymous]

Hi,

I am building a dashboard to track response rates to emails.

I have a number of columns in the table, and the ones i need to use are Received Time, and Subject.

The table is sorted by received time, oldest to newest.

I want to add a column that wil put a 1 against the earliest instance for each Subject.

I would like to then do the same for the second, third, fourth etc, but this would be an added bonus.

Can anyone help?

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may try using RANKX Function.

http://community.powerbi.com/t5/Desktop/How-to-get-the-latest-status-by-id/m-p/260538#M116405