Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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
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
@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/
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |