Daily DAX : Day 360 INFO.CHANGEDPROPERTIES

DAX INFO.CHANGEDPROPERTIES Function

Description

The INFO.CHANGEDPROPERTIES function in Power BI DAX (Data Analysis Expressions) returns a table containing information about properties that have changed in the current session or calculation context. It is primarily used for debugging and understanding how calculations or data model changes impact results.

Syntax

INFO.CHANGEDPROPERTIES()

Returns: A table with columns describing changed properties, such as property names, old values, and new values.

Columns in the Result Table

• PropertyName: The name of the changed property.
• ObjectName: The name of the object (e.g., table, column) affected by the change.
• OldValue: The previous value of the property.
• NewValue: The new value of the property.

Use Case

INFO.CHANGEDPROPERTIES is useful in scenarios where you need to track or debug changes in the data model or calculation context, such as:

• Debugging Calculations: Identify how measures or calculated columns are affected by changes in properties during query execution.
• Monitoring Model Changes: Track modifications to table or column properties in dynamic calculations.
• Performance Optimization: Understand which property changes impact query performance.

Example

Suppose you want to track changes in a measure's properties during a calculation. You can use the following DAX query:

EVALUATE
INFO.CHANGEDPROPERTIES()
    

This returns a table listing any properties that changed in the current session, such as format strings or visibility settings.

Notes

• This function is part of the DAX INFO functions, introduced to provide metadata about the data model.
• It is most useful in DAX queries executed in tools like DAX Studio for advanced debugging.
• The function does not accept parameters.

Limitations

The function only captures changes within the current session or query context and may not reflect all historical changes in the data model.