Scribd
Upload
10 views5 pages

Power Query Table Functions Overview

Uploaded by

RamanKumarJha
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views5 pages

Power Query Table Functions Overview

Uploaded by

RamanKumarJha
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Power Query Table Functions Part 1

1. [Link]
Description:
Adds a custom column to a table, using a formula to calculate the values.
Example:

Result:

Use Cases:
•Adding calculated columns based on existing data.
•Creating derived values like percentages, ranks, or aggregates
2. [Link]
Description:
Adds an index column to a table, starting from a specified initial value and increment.
Example:

Result:

Use Cases:
•Creating unique identifiers for rows.
•Sorting or ranking rows.
3. [Link]
Description:
Adds a column containing the rows of the join results from another table based on matching key values.
Example:

Result:

Use Cases:
•Merging datasets with relationships.
•Augmenting data by adding columns from related tables.
4. [Link]
Description:
Adds a column that ranks rows based on a value column.

Example:

Result:

Use Cases:
•Ranking performance or metrics.
•Creating leaderboards.

You might also like