Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
This must be very easy, but I don't remember at the moment. The goal is to create a new table based on Table1:
Only the rows containing the smallest Value of every Category should go to the new table. Resulting in this:
What formula can I use?
Solved! Go to Solution.
@Zyg_D , you can create a new table like
summarize(Table, Table[Category], Table[Info], "Value", min(Table[Value]))
or use measure min(Table[Value]) with Category and Info in table or matrix visual
@Zyg_D , you can create a new table like
summarize(Table, Table[Category], Table[Info], "Value", min(Table[Value]))
or use measure min(Table[Value]) with Category and Info in table or matrix visual