Forum Discussion
Solved
Filtering a table on the Max date by department
Hi - I am trying to do the following (I posted something earlier this month and I think the example was incorrect). I would like to pull the max date based upon a specific department. Input: D...
Thank you everyone for examples and assistance - appreciate it.
I ended up doing the following:
- Sort by Department (Ascending) then by date (Decending - putting the most recent date first)
- Adding ranking logic by Department
- The result is the most recent date results in a ranking of 1 for each departmnt
- Filter on the 1 Ranking
As the data dynamically updates, I will always get the most recent date.
Thanks - Jerry
Hi MasonMA
Thank you again for your help.
Ok so my question is this - exactly where do I put that code inthe Power BI / Power Query workflow ?
I already have a lot of code in the workflow when I click on the 'advanced editor' - do I add the code below to the end?
thanks - Jerry
