Forum Discussion

lzorn's avatar
lzorn
Frequent Visitor
8 years ago
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 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

  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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