Hello everyone.
for your help with the following:
I have a table with transactions of income and exit and I intend to identify of all the records that are made those who have not yet left, investigating I saw that the SUMMARIZE function, it was useful for me to group the records by ID with the maximum date for each ID for the most recent record.
Table created.
TABLE1 = SUMMARIZE('Consolidated', 'Consolidated'[ID], "Date",MAX('Consolidated'[Date]))
To this table I am trying to make a "Lookupvalue", which allows me to bring the last transaction (Entry or Exit) passing an additional meter to the formula (Table 1.Date and Table 2.Date.
LOOKUPVALUE(Table1[Transaction],
Tabla1[ID],Tabla2[ID],
Table1[Date],Table2[Date])
But I get the following error message "A multi-valued table was provided where a single value was expected" was provided.
Please your guidance on how I can solve this error or how I can achieve what I want to do, thank you very much.
