Getting max values in dim_date

[Easley06]

Hi,

how to get max values if my dim_date having up to 2050 

i cant get the dates in my fact table sincei i have two date columns that connected in my dim_date

active and inactive relation so i need to get the date from my dim_date

example:

max attrition%1 = CALCULATE(vw_Employee_Attrition[Attrition%],LASTDATE(DIM_Date[MonthYear]))

thankyou.

[amitchandak]

@Easley06 , The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

Check if these blogs or attached file can help

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...