Forum Discussion

ysapiyev's avatar
ysapiyev
Responsive Resident
7 years ago
Solved

Filter last date in table

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

Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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