Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
_chris_
Helper II
Helper II

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

2 REPLIES 2
_chris_
Helper II
Helper II

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
Super User
Super User

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors