Forum Discussion
nirvana_moksh
Impactful Individual
Impactful IndividualDAX formula for latest text value
Hello All, I had a previously working DAX formula which worked fine after a lot of testing too, but I am questioning its validity now. I have a table like below. Where the ID column can repeat mu...
Hi,
These are the DAX formulas i used
Most recent date = MAX(Data[INSERT DATE])
Most recent description = LOOKUPVALUE(Data[DESCRIPTION],Data[INSERT DATE],[Most recent date],Data[ID],MAX(Data[ID]))
nirvana_mokshImpactful Individual
Impactful IndividualI just tried yours and it works perfectly! Just one question, for the part '[Most recent date]' in your DAX formula I substiuted that with MAX(Insert Date) and that worked, but will this work per ID? Meaning will it look at the MAX of Insert Date per ID even if they are more than 1 or will it see MAX of Insert Date for the entire data table of ID's?
Ashish_Mathur
Super User
Super UserYes, it will work per ID. If my reply helped, please mark it as Answer.