I am basically trying to get the number of days between the latest date from the reference table and the current date. I thought MAX was supposed to get me the latest date through the last id match but I only get the first one.
This is my formula:
CONCATENATE(HOUR (Today() - MAX(SELECT(Contact_txn[Date], [id] = [ContactRec])))/24, " Days Ago")
The concatenation of all these text values (
…(TODAY() - MAX(
…The list of values of column ‘Date’
…from rows of table ‘CONTACT_TXN’
…where this condition is true: ((The value of column ‘id’) is equal to (The value of column ‘ContactRec’)))) / 24
…" Days Ago"
I am not sure what I am missing. Any help would be appreciated.