Transform Tab in Query Editor: The "standard" options in Power BI's Query Editor', such as Add, Multiply, subtract...: Lesson-7 P-8.2
The "standard" options in Power BI's Query Editor's Transform ribbon: Lesson-7 P-8.2
The "standard" options in Power BI's Query Editor's Transform ribbon, such as Add, Subtract, Multiply, etc., refer to basic mathematical operations that can be applied to numeric columns in your dataset. These operations allow you to perform calculations on your data directly within Power BI, without the need for external tools or scripts. For example:
- Add: Allows you to add a constant value or the values of two columns together.
- Subtract: Enables you to subtract a constant value or values in one column from another.
- Multiply: Lets you multiply a column by a constant value or by the values of another column.
- Divide: Allows you to divide a column by a constant value or the values of another column.
- and more...
These operations are necessary to create calculated columns or modify existing columns to gain new insights or perform data transformations as per your analysis and reporting needs in Power BI.
Lab Work
The "standard" options in Query Editor's Transform ribbon(Tab),
Standerd Options of query editor
- open query editor (Transform data) in Home ribbon
- Select Transform tab
- Select standard icon from Transform ribbon
- select required option(action) from list of standard option
1:- Add
- Add specific value in each values of selected column (coulumn must be numaric)
- select required column
- Transform --> Standerd --> Add
after click on add option
now 100 add in every values of selected column
then you have
2:- Multiply
- Multiply specific value with each values of selected column (coulumn must be numaric)
- select required column
- Transform --> Standerd --> Multiply
then you have
3:- Subtract
- Subtract specific value from each values of selected column (coulumn must be numaric)
- select required column
- Transform --> Standerd --> Subtract
Final view
4:- Divide
- Divide by specific value of each values of selected column (coulumn must be numaric)
- select required column
- Transform --> Standerd --> Divide
then you have
5:- Integer - Divide
- Divide by specific number to each values of selected column (coulumn must be numaric) output must be integer not float
- select required column
- Transform --> Standerd --> Integer - Divide
then you have view with integer (real) number
6:- Modulo
- Give the remainder vlalues (coulumn must be numaric)
- select required column
- Transform --> Standerd -->Modulo
result view
7:- Percentage
- How many percentage to calculate all values of selected column (coulumn must be numaric)
- select required column
- Transform --> Standerd -->Percentage
After calculation
8:- Percentage of
- Calculate the percentage of values (coulumn must be numaric)
- select required column
- Transform --> Standerd --> Percentage Of
Thanks
