Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to Show Last 5 Rows by Date

I want to show a table that only shows the last 5 rows by date. Meaning: I only want the latest 5 data rows to be shown. Is there a way to achieve this?

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi raghads ,

     

    Relative filter can meet your requirement, input Top N = 5 then put date column into based column as below:

      

     

    Regards,

    Jimmy Tao

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi raghads ,

     

    Relative filter can meet your requirement, input Top N = 5 then put date column into based column as below:

      

     

    Regards,

    Jimmy Tao