Power BI offers a variety of transformations that can be applied to data during the data modeling and data preparation stages. Here are some of the most commonly used transformations in Power BI:
- Splitting columns: This transformation splits a column into two or more columns based on a specified delimiter or pattern.
- Changing data types: This transformation allows you to change the data type of a column to a different data type, such as changing a string to a number.
- Filtering rows: This transformation allows you to filter rows based on specific criteria, such as filtering out rows with null values.
- Grouping and aggregating: This transformation allows you to group data by one or more columns and perform aggregate functions such as sum, count, or average on the grouped data.
- Adding calculated columns: This transformation allows you to add new columns to a table that are calculated based on the values in other columns.
- Merging tables: This transformation allows you to combine two or more tables into a single table based on a common column.
- Pivot and unpivot: Pivot allows you to transform rows into columns, while unpivot transforms columns into rows.
- Renaming columns: This transformation allows you to rename columns to more meaningful names.
- Removing columns: This transformation allows you to remove unnecessary columns from a table.
- Combining queries: This transformation allows you to combine multiple queries into a single query, such as combining data from multiple Excel files or databases.
These are just a few of the most commonly used transformations in Power BI, but there are many more available depending on your specific data needs.
