Daily DAX : Day 374 BITAND

Power BI DAX BITAND Function

Description

The BITAND function in Power BI DAX performs a bitwise AND operation on two integer values. It compares each bit of the two numbers and returns a result where each bit is set to 1 only if both corresponding bits in the input numbers are 1.

Syntax

BITAND(<number1>, <number2>)
  • number1: The first integer value.
  • number2: The second integer value.

Return Value: An integer representing the result of the bitwise AND operation.

How It Works

The BITAND function converts the input numbers to their binary representation, performs a bitwise AND operation, and returns the result as an integer. For example:

  • BITAND(5, 3)
  • Binary of 5: 0101
  • Binary of 3: 0011
  • Bitwise AND: 0101 & 0011 = 0001
  • Result: 1 (in decimal)

Use Case

The BITAND function is useful in scenarios involving bitmasking or flag-based data analysis. For example, it can be used to check if specific permissions or settings (represented as bits) are enabled in a system.

Example Scenario: In a database, user permissions are stored as integers where each bit represents a specific permission (e.g., bit 1 = read, bit 2 = write). You can use BITAND to check if a user has specific permissions.

PermissionCheck = BITAND(UserPermissions, 2)

If UserPermissions = 6 (binary: 0110, meaning read and write permissions), then BITAND(6, 2) returns 2, confirming the write permission (bit 2) is set.

Example in DAX

Result = BITAND(10, 12)
  • Binary of 10: 1010
  • Binary of 12: 1100
  • Bitwise AND: 1010 & 1100 = 1000
  • Result: 8 (in decimal)

Notes

  • Both inputs must be integers; non-integer values are truncated to integers.
  • Negative numbers are supported and handled in two's complement form.
  • Commonly used in technical or low-level data scenarios, such as analyzing flags or binary states.

Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 131 SELECTEDMEASURE

 The SELECTEDMEASURE function in Power BI's DAX (Data Analysis Expressions) language is a powerful tool used primarily within calculation groups to dynamically reference the measure currently being evaluated in a report. It’s part of the calculation group feature introduced to streamline complex reporting scenarios and improve maintainability by reducing the need to duplicate measure logic. What is SELECTEDMEASURE? SELECTEDMEASURE is a DAX function that returns a reference to the measure that is currently active or "selected" in the context of a calculation group. It doesn’t take any arguments and is typically used in the expression of a calculation item within a calculation group. This allows you to write generic logic that can dynamically apply to whichever measure is being evaluated in a visual, without hardcoding specific measure names. Syntax SELECTEDMEASURE()     Returns: A reference to the measure currently being evaluated in the report context. Use Case SELECTEDME...
Read more

Daily DAX : Day 446 INFO.CSDLMETADATA

Power BI DAX Function: INFO.CSDLMETADATA INFO.CSDLMETADATA` is a specialized DAX function introduced as part of a broader set of "INFO" functions (like `INFO.TABLES` or `INFO.MEASURES`) used for **model introspection**. It allows you to programmatically access the underlying structure of your Power BI semantic model. What does it do? The function returns a table with a single column containing the Conceptual Schema Definition Language (CSDL)  metadata of your model in XML format . In plain English, it exports a highly technical "blueprint" of your entire data model—including tables, columns, relationships, and measures—as a structured XML string. It is essentially the DAX equivalent of the `DISCOVER_CSDL_METADATA` Dynamic Management View (DMV) used in Analysis Services. --- Syntax and Output The syntax is straightforward as it requires no arguments: ```dax EVALUATE INFO.CSDLMETADATA() ``` Return Value : A table with one column and one row. Content : A long string ...
Read more

Daily DAX : Day 453 ENDOFWEEK

Power BI DAX Function: ENDOFWEEK Description The ENDOFWEEK function is a Time Intelligence function in DAX (Data Analysis Expressions) used in Power BI. It returns the date that represents the end of the week containing a specified date (typically Saturday, as weeks are considered to start on Sunday by default in DAX time intelligence). Syntax ENDOFWEEK( [, ]) : A column reference (usually from a Date table) or a date expression. Required. : Optional. Specifies the week-ending convention. Default is Saturday if omitted. Examples 1. Basic usage (default: week ends on Saturday): End of Week = ENDOFWEEK('Date'[Date]) For a date like January 8, 2026 (Thursday), this would return January 10, 2026 (Saturday). 2. In a measure for cumulative sales up to end of week: Total Sales to End of Week = CALCULATE( SUM(Sales[Amount]), DATESBETWEEN('Date'[Date], ST...
Read more