Forum Discussion
DAX or M for efficiency - Staff Database
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?
Community ChampionAnonymous 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.
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
Anonymous Ah, shoot, yeah I don't do much in Excel. In Desktop you doubleclick the relationship and switch it.