Filter last date in table

[ysapiyev]

Hi everyone.

I have a table with sporadic data with entries for different date for various item. I want to filter last date value for each item. I tried to apply TOP N filtration, but it showed not last value. How can I use filter to take last date? 

I tried using calculated measures, but in live connection I couldn't use it.

Regards,

Yerkhan

[v-cherch-msft · Accepted solution]

Hi @ysapiyev

You may try to use 'Latest' for the date. If it is not your case, please share some data sample and expected output.

Regards,

Cherie