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?

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

Since bi-directional filtering isn't available for you in Excel, you may want to resort to expanded table for invert filter propagation from * to 1 end.

Expanded tables in DAX - SQLBI  

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks CNENFRNL, would that be quicker than the proposed solution of using a couple of calculated columns using the DAX MAX function?  I can't quite see how it would help me because of the multiple rate problem I'm trying to address - it seems to essentially be flattening the table.