Forum Discussion
Solved
Lookup update by last know date
Hi, I have a ''Current'' table, in which updates are logged. This table contains every new update that comes in (System, date update, update status). And a second table in which i want to show t...
Hi lzorn,
Maybe you can try to use summarize function to create new table with last updated data.
Sample table formula:
last status = SUMMARIZE ( Table, [System], "last date", LASTDATE ( Table[date update] ), "Last status", LASTNONBLANK ( Table[update status], [update status] ) )In addition, you can also take a look at following link about create a measure to lookup value.
Regards,
Xiaoxin Sheng
Hi lzorn,
Maybe you can try to use summarize function to create new table with last updated data.
Sample table formula:
last status =
SUMMARIZE (
Table,
[System],
"last date", LASTDATE ( Table[date update] ),
"Last status", LASTNONBLANK ( Table[update status], [update status] )
)
In addition, you can also take a look at following link about create a measure to lookup value.
Regards,
Xiaoxin Sheng