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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
66 | |
63 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |