BITOR
A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
What is the BITOR function?
The BITOR function is a DAX function that performs a bitwise OR operation between two or more numbers. A bitwise OR operation compares each corresponding bit of the numbers and returns a new number with bits set to 1 where either or both of the corresponding bits are 1.
Syntax
The syntax for the BITOR function is as follows:
BITOR(Number1, Number2, ...)
Where `Number1`, `Number2`, etc. are the numbers to be compared.
Examples
Let’s look at some examples to understand how the BITOR function works.
Example 1:
Suppose we have two numbers:
Number1 = 5
Number2 = 3
We want to perform a bitwise OR operation between these two numbers. We can do this using the BITOR function:
BITOR(5,3)
This will return the result `7`.
Example 2:
Suppose we have three numbers:
Number1 = 1
Number2 = 2
Number3 = 4
We want to perform a bitwise OR operation between these three numbers. We can do this using the BITOR function:
BITOR(1,2,4)
This will return the result `7`.
How to use the BITOR function in Power BI
Now that we understand how the BITOR function works, let’s see how we can use it in Power BI.
Suppose we have a table with two columns: `ID` and `Status`. The `ID` column contains unique identifiers for each row, and the `Status` column contains a number that represents the status of each row.
Suppose we want to filter this table to show only the rows that have a status of `1` or `2`. We can do this using the BITOR function in a measure.
1. First, go to the “Modeling” tab in Power BI and click on “New measure”.
2. In the formula bar, enter the following formula:
FilteredTable = FILTER('Table', BITOR('Table'[Status],1) = 'Table'[Status] || BITOR('Table'[Status],2) = 'Table'[Status])
Here, `Table` is the name of our table, and `Status` is the name of the column that contains the status values.
3. Give a name to this measure, for example, “FilteredTable”.
4. Now, go to the “Visualizations” tab and add a new table visual.
5. Add the `ID` and `Status` columns to the table visual.
6. Finally, drag and drop the “FilteredTable” measure to the “Filters” section of the visualizations pane. This will filter the table to show only the rows that have a status of `1` or `2`.
In conclusion, the BITOR function in Power BI’s DAX language is a powerful tool that can help you perform complex bitwise OR operations in an automated and efficient way. By using this function in a measure, you can filter tables based on logical expressions that involve multiple bits. With the help of this article, you should now be able to use the BITOR function in your Power BI projects.