Forum Discussion

kroman's avatar
kroman
Helper II
5 years ago
Solved

Sort 5 top records by selected date

Hi All I have site pages visits report in a sharepoint list and I am trying to show 5 most visited pages that can be filtered by selected date. So I have 7 buttons on a top (slider, button for each ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.  There is another way to solve this via the Rank function.

    Hope this helps.

kroman's avatar
kroman
Helper II
5 years ago

Just want to add some edetails - so I have following table:

Date -- File  --- Operation    

13.12    File1     Download 
13.12    File2     View
14.12    File1     Download 
14.12    File3     Download 
14.12    File3     Download 
14.12    File1     View 
14.12    File1     View
.... and so on , few 1000 of them
and, obviosly, I have Dates table 

  So I need to be able to see most downloaded/viewed files for the whole time and, when particular date selected, during that date, so some kind of destintion 

Thanks 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

You may download my PBI file from here.  There is another way to solve this via the Rank function.

Hope this helps.

  • kroman's avatar
    kroman
    Helper II
    5 years ago

    Thanks a lot Ashish, that exactly what I needed ğŸ˜€

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      You are welcome.