Forum Discussion
Impactful IndividualDAX formula for latest text value
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]))
Super UserHi,
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_mokshThanks a lot Ashish, upon doubling checking my DAX formula I found out the reason for my suspicion was because the relationship between the two tables was broken which is why my results on the visulations were so weird. Out of curiosty, did you have a chance to give my DAX formula a look? Just wanted a confirmation if that is still good.
- Ashish_Mathur
I did not try your DAX formula. Did you try mine? Is it working fine?
- nirvana_moksh
I 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
Yes, it will work per ID. If my reply helped, please mark it as Answer.