New transform – percentiles

  • Article

Important

This content is archived and is not being updated. For the latest documentation, go to Integrate data into Microsoft Dataverse. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically - May 6, 2022

Business value

A transformation to create percentiles will give you more statistical information about your data.

Feature details

We're planning to add percentiles as a transformation to the group by capabilities in Power Query Online. You can get more statistical information on your data profile that will help by better preparing the data.

Group by dialog with the Percentile Operation for two new columns P50 and P75.

See also

Grouping or summarizing rows (docs)