![]() ![]() You will also need to enter a new column name to contain the aggregated data and select a column containing the numeric data to be aggregated. ![]() This is where you’ll see the new Percentile option in the Operation dropdown box if you select it another box will appear underneath the Operation dropdown box where you can enter a number between 0 and 100 to indicate which percentile should be returned when the data is aggregated. When you do this the Group By dialog will open with the Country column selected in the Group by dropdown box. If you connect to this table from a Power BI or Power Platform dataflow, you can select the Country column and click the Group by button on the Transform tab in the ribbon: ![]() To see how it works, let’s see a simple example.Ĭonsider the following Excel table containing information about invoices from different countries: There’s a new operation available for the Group By transformation in Power Query Online: percentiles. This content applies to: Power Query online ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |