Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hello! Is there a way to create an IF/THEN function that reads from the aggregated data nested in each row after grouping by certain column?
I grouped by TRACKER and inserted an index that counts the value appearance over time. I want Power Query to locate the largest number in the index column and assign a classification to it, leaving the rest with another text ("CLOSED" and "OPEN").
As an alternative I then expanded and merged the TRACKER and INDEX columns but haven´t found the way to classify it.
Any suggestions are welcome, Thank you!!
=Table.Combine(Table.TransformColumns(#"Grouped Rows",{"COUNT TRACKER",each Table.CombineColumns(Table.AddIndexColumn(_,"idx",1),{"TRACKER INDEX KEY","idx"},each _{0}&Text.From(_{1}),"TRACKER INDEX KEY")})[COUNT TRACKER])
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 5 | |
| 4 | |
| 4 |