Forum Discussion

_chris_'s avatar
_chris_
Icon for Helper III rankHelper III
3 years ago

Help with simple measure needed

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    _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)

  • _chris_'s avatar
    _chris_
    Icon for Helper III rankHelper III
    3 years ago

    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