Most Recent Field Based on Date

[MITeam]

Hi. I am trying to create a table to show candidate name / Location info / total hours - I need a slicer for date range and I need one line per candidate but they can work in many locations so I need to somehow pull through 1 location which will be the most recent one worked in the date range selected

My table would be Name / Recent Location / Total hours at all locations all based on the date range in a slicer.

I cant work this out. In excel I guess I would do a max if on the date and xlookup on a concatenation of the max date and candidate name to pull through the most recent locations etc.

The date selector would not necessarily include thier most recent shift so it has to be dynamic to what is selected.

Any help appreciated - I am going cross eyed

[amitchandak · Accepted solution]

@MITeam , refer if this approch can

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

[MITeam]

Appreciate it - I was havong a moment and could not work out what to even search for lol