Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Group Rows In Table Power Query. Note if multiple keys match the comparer different keys may be returned. Hi I am new to PowerBI Desktop.
Excel Power Query Enter The Path And Name Of A Source File In A Cell To Make It Easier To Move After You Have Set Up Power Software Development Sharepoint from www.pinterest.com
In the Group by dialog box select Advanced to select more than one column to group by. Note if multiple keys match the comparer different keys may be returned. I have two separate table for County and City.
Heres the step by step of what we need to do.
To do more than one operation you should select the Advanced bullet in the top of the screen. Note if multiple keys match the comparer different keys may be returned. For each group a record is constructed containing the key columns and their values along with any aggregated columns specified by aggregatedColumns. For each group a record is constructed containing the key columns and their values along with any aggregated columns specified by aggregatedColumns.
