Forum Discussion
cmilligan262
Helper II
Helper IILatest Date in same Month
I currently use a calculated column to find the most recent date in a table for a specific person. Max Date = calculate(Max('2020 Combined Roster'[Date]),Filter('2020 Combined Roster','2020 Comb...
cmilligan262Helper II
Helper IIamitchandak So that's not quite working how I need it to. For example since it is not currently march and I have no data for march I want to to show the latest data for that person when I select march
amitchandak
Super User
Super UserCan you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970