Transform Tab in Query Editor: The "Information" options like Is Even, Is Odd and Sign in Power BI's Query Editor: Lesson-7 P-12
The "Information" option in Power BI's Query Editor:
Within the Transform tab of Power BI's Query Editor, the "Information" option offers three functions specifically designed to display information about your numerical data:
1:- is even:
- Purpose: Checks each value in the selected column and returns FALSE if the value is an even number (exactly divisible by 2) and otherwise.
- Use Case: Helps identify similarly numbered values for further analysis or filtering. For example, you can use it to analyze sales data on even or odd days of the week.
2:- Is Odd:
- Purpose: Like "also", this function checks for odd numbers (not completely divisible by 2).
- Use case: Indicates odd-numbered values within a column. This can be useful for comparing or filtering data based on odd/even patterns.
3:- sign:
Purpose: Determines the sign (positive, negative, or zero) of each value in the selected column.
Use Case: Helps understand the distribution of positive, negative, and zero values in your data. This can be valuable for tasks such as identifying outliers or analyzing financial data.
Access these functions:
Select Column: Select the numeric column you want to analyze.
Transform Tab: Go to the “Transform” tab.
Information button: Click the "Information" button
A new column is added to your table with the results of the selected function ("is even," "odd" or "sign"). This new column displays TRUE/FALSE for even/odd checks and positive/negative/blank for signs.
Important Note:
Note: These functions only work with numeric data types.
Lab Work
The "Information" options (Menu)
Steps:
- Home --> Transform data --> Transform data
- Select a Numeric Column or Columns
1:- Is Even
- return true if number is even and false if numer is not even
- Transform --> Information --> Is Even
Then you have:
1:- Is Odd
- return true if number is Odd and false if numer is not Odd
- Transform --> Information --> Is Odd
Then you have:
3:- Sign
- rreturn 1 if number is positive and return -1 if number is negative & 0 for zero value
- Transform --> Information --> Sign
View
Thanks