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

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

Microsoft Power BI Table of Contents: Lessons Index