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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.