Forum Discussion

ostur's avatar
ostur
Frequent Visitor
2 years ago
Solved

Sorting by most recent date

I really hope you can help me, and save me from a major headache.   My problem is that I have a list of names, grouped into several categories, but the way my system works is that every change to t...
Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    Hi ostur 

     

    This informative video will help filter by the latest date https://www.youtube.com/watch?v=hidJ5T_DYQ0 

     

    In Power Query 

    • highlight the Name column and in the ribbon, click on Group by
    • Add a new Column Name, lets say MaxDate, In Operation choose Max and Choose in Column the Date Column
    • Add another aggrigation and name it All. Operation should be All
    • Press OK
    • Expand the new column and untick Name as it's already in the table
    • In the MaxDate column filter the date to today
    • Then in the measure change todays date to the date column 

     

     

     

    =[Date]​

     

     

     

    • This will show the last entry and it is dynamic, if there changes in the future, then these will be implemented.

     

     

    Thanks

    Joe

     

    If this post helps, then please Accept it as the solution 

JoeBarry's avatar
JoeBarry
Solution Sage
2 years ago

Hi ostur 

 

This informative video will help filter by the latest date https://www.youtube.com/watch?v=hidJ5T_DYQ0 

 

In Power Query 

  • highlight the Name column and in the ribbon, click on Group by
  • Add a new Column Name, lets say MaxDate, In Operation choose Max and Choose in Column the Date Column
  • Add another aggrigation and name it All. Operation should be All
  • Press OK
  • Expand the new column and untick Name as it's already in the table
  • In the MaxDate column filter the date to today
  • Then in the measure change todays date to the date column 

 

 

 

=[Date]​

 

 

 

  • This will show the last entry and it is dynamic, if there changes in the future, then these will be implemented.

 

 

Thanks

Joe

 

If this post helps, then please Accept it as the solution 

  • ostur's avatar
    ostur
    Frequent Visitor
    2 years ago

    Thank you so much Joe, you're a lifesaver!