Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX or M for efficiency - Staff Database

Hi! I have a timesheet database I'm trying to make more efficient.  A cut down version is attached.   "staff" will contain information about the staff member (just has a resource ID no at the mome...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    So I've used MAX for the lookup to get the value as a helper column and then the rate from there.  I realised the duff data I put in for the example made no logical sense, so adjusted some of the timesheet and grade dates to occur in the past. 

     

     

    Is this just the easiest way of doing it, or is there a more efficient way?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous Well you could use LOOKUPVALUE or MAXX(FILTER(...),...). Or, if you changed a couple of your relationships to Both you would have a filter pathway between timesheets and rates tables.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

So I've used MAX for the lookup to get the value as a helper column and then the rate from there.  I realised the duff data I put in for the example made no logical sense, so adjusted some of the timesheet and grade dates to occur in the past. 

 

 

Is this just the easiest way of doing it, or is there a more efficient way?