Time Lapse

[bhmiller89]

I have a column called "WorkDate" for Job Reports. Each Job Number has multiple Job Reports. I need to ultimately figure out how to show Job Numbers that have not had a Job Report entered within the last 90 days. I wrote a measure LastJR= MAX(WorkDate) but got stuck after that

[vmakhija · Accepted solution]

@bhmiller89

You can use the below measure:

MAX_WorkDate = DATEDIFF(

CALCULATE(MAX(Job_Report[WorkDate]),ALLEXCEPT(Job_Report,Job_Report[JobNumber])),

NOW(),

DAY)

I assumed your data might look like below -

So MAX_WorkDate will give you number of days.

Regards

[vmakhija]

@bhmiller89

Can you please post some sample data to better explain your requirement.

Regards