Forum Discussion

ysapiyev's avatar
ysapiyev
Icon for Responsive Resident rankResponsive Resident
8 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

  • 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
    Icon for Microsoft Employee rankMicrosoft Employee

    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