Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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])
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.