I'm looking for a way to find how many days since a rep had a new job turned in.
I'm using the Job table, document date table, and vd_JobRep Table. I've tried adding a measure of
Without diving too deep into your issue,
I would think you would want to do a DateAdd measure to count the days from the date showing on your report (or all dates) and the Job created date. And then find the Max for that. It can all be done in one measure.
Choose a location