Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have two tables.
Table 2 filters Table 1 in my modell in PowerBi. I want to get a new table which contains all rows of table 1 with the highest result_id filtered by different the rivet_point's which are in a column of table 2. There are many result_id's for each rivet_point. But I want only the last result_id for each rivet_point which means the highest result_id for every rivet_point.
I hope you can help me
Table 1:
Table 2:
@dmilardo_au , Assuming both are related based on rivet_point
a new table = filter( addcolumns( Table1,
"Col1" = maxx(filter(Table2, Table1[rivet_point] = table2[rivet_point]), Table2[result_id]) )
, Table2[result_id] = [Col1])
Thanks for your response @amitchandak.
I tried it but I get the warning that ADDCOLUMNS needs 3 arguments.
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |