DAX Get latest value with from other tableau based on condition

[kathraji]

Hi Everyone,

I've two tables A and B with the following data.I'm trying to have one table with the latest value fr code'0' for each name

Table A

name	code
name1	1
name2	1
name3	1

TableB

name	code	updated_at
name1	0	10/12/2017
name1	0	15/12/2017
name2	0	07/1/2020
name2	0	25/1/2020
name3	0	19/04/2020

The resulting table should like this

name	code	updated_at
name1	1
name1	0	15/12/2017
name2	1
name2	0	25/1/2020
name3	1
name3	0	19/04/2020

Please help.

[v-deddai1-msft · Accepted solution]

Hi @kathraji ,

It is a slight modification of amitchandak‘s reply:

Table =
UNION (
    SUMMARIZE (
        TableB,
        TableB[name],
        TableB[code],
        "updated_at", MAX ( TableB[updated_at] )
    ),
    ADDCOLUMNS ( TableA, "updated_at", BLANK () )
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@kathraji , see if this can work

union (
summarize(Table2, Table[name code],"updated_at" , max(updated_at)),
addcolumns(Table A,"updated_at" ,blank())
)

refer

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/