Forum Discussion
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...
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?
Hey Greg - stupid question, how do you change the direction to both? Not something I've come across. A quick google isn't coming up, so I obviously don't know what keyword to search for!
ah, looking at this, I think this is PowerBI only, not excel specific, so can't seem to do that 🙂
- Greg_Deckler
Community Champion
Anonymous Ah, shoot, yeah I don't do much in Excel. In Desktop you doubleclick the relationship and switch it.
