Help with simple measure needed

[_chris_]

Hi,

I have a table that holds project operations. I have another table which has the timebooking of the employees for these project operations. I have a relationship between both tables.

Now I want to show the amount of days since the last time booking per project operation.

I created this measure: Days since last booking = DATEDIFF(TODAY(), LASTDATE(EmployeeTimeBooking[Date]), day)

The measure can be saved. However, when I start drawing it into my table, the table does not load anymore for one hour and afterwards I get an error message saying "not enough resources".

BTW, I am using Direct Query.

Can someone help me here?

Thanks, Christian

[_chris_]

Hi, thanks for your answers.

Unfortunately, with both formulas, I am running into the same problem as with my formula. The wheel is turning and turning...No result

Do you have any other idea?

Thx, Christian

[amitchandak]

@_chris_ , if you need max date from the table try like

measure  =

var _max = maxx(allselected(EmployeeTimeBooking), EmployeeTimeBooking[Date])

return

DATEDIFF(TODAY(), _max , day)

or try like

DATEDIFF(TODAY(), max(EmployeeTimeBooking[Date]), day)