Forum Discussion
Solved
Calculated column Table - Dates
Hi everyone, I was hoping someone could help me with this report. Essentially my report includes 2 tables. X_Payroll' that summarizes the various pay periods for an employee and X_Employment' ...
no need to modify the DAX, update the relationship between tables.
pls see the attachment below
pls try this
Column =
VAR a=maxx(FILTER('x_employeement','x_employeement'[effective]=max('x_employeement'[effective])),'x_employeement'[pay rate])
VAR b=maxx(FILTER('x_employeement','x_employeement'[effective]<='x_payroll'[date]&¬(ISBLANK('x_employeement'[pay rate]))),x_employeement[effective])
return if('x_payroll'[date]>max('x_employeement'[effective]),a,maxx(FILTER(x_employeement,'x_employeement'[effective]=b),x_employeement[pay rate]))
pls see the attachement below