Lookup update by last know date

[lzorn]

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 the latest update for a system (System, last update status).

I want to filter on date so that the last known update is shown. Can somebody help me with the right code for Power BI?

Kind Regards,

Léjon

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[v-shex-msft · Accepted solution]

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.

DAX Last Date - Other field

Regards,

Xiaoxin Sheng