What the DAX?

Power BI DAX Function: CURRENTGROUP Description The CURRENTGROUP function in DAX (Data Analysis Expressions) is used within the context of a calculation to reference the current group of rows in a grouped calculation, such as in a SUMMARIZE or ADDCOLUMNS function. It is primarily used in Power BI to access the rows in the current group during iterative calculations over grouped data. Syntax CURRENTGROUP() Returns: A table containing the rows of the current group in the grouping operation. Use Case CURRENTGROUP is commonly used with the SUMMARIZE function to perform calculations on a group of rows. It allows you to reference the subset of data in the current group for further calculations, such as aggregations or filtering within the group. Example Suppose you have a sales table with columns Region , Product , and SalesAmount . You want to calculate the total sales for each region and then find the percentage co...

Power BI DAX RADIANS Function Description The RADIANS function in Power BI DAX converts an angle from degrees to radians. Many trigonometric calculations, such as those involving SIN , COS , or TAN , require angles in radians rather than degrees. Syntax RADIANS(number) number : The angle in degrees (required). Return Value The angle converted to radians (numeric value). Use Case The RADIANS function is useful in scenarios involving trigonometric calculations, such as: Calculating distances between geographic coordinates using the Haversine formula. Performing calculations in engineering or physics dashboards that involve angles. Creating visualizations that require trigonometric transformations. Example Suppose you have a column Degrees with an angle value of 180. You want to convert it to radians for use in a SIN calculation. SineOfAngle = SIN(RADIANS(180)) R...

Power BI DAX: OPENINGBALANCEYEAR Function Description The OPENINGBALANCEYEAR function in Power BI DAX (Data Analysis Expressions) calculates the balance of a specified measure or column at the start of a given year . It is commonly used in financial and time-intelligence analysis to retrieve the opening balance for a year based on a date column and a measure or expression. Syntax OPENINGBALANCEYEAR(<expression>, <dates>[, <filter>][, <year_end_date>]) expression : The measure or column to evaluate (e.g., sum of sales or account balance). dates : A column containing date values, typically from a Date table. filter (optional): A filter expression to apply to the calculation. year_end_date (optional): A literal string defining the year-end date (e.g., "12/31" for December 31). If omitted, it assumes December 31. Return Value The value of the expression calculated...

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,...

Power BI DAX TREATAS Function Description The TREATAS function in Power BI DAX (Data Analysis Expressions) is used to apply the values from one table as filters to another table, treating the values as if they belong to the columns of the target table. It is particularly useful for creating virtual relationships between tables without a physical relationship in the data model. Syntax TREATAS(table_expression, column1 [, column2, ...]) table_expression : A table or expression that returns a table containing the values to be used as filters. column1, column2, ... : The columns in the target table to which the values from the table_expression are applied. Use Case TREATAS is commonly used when you need to filter a table based on values from another table without an explicit relationship. This is helpful in scenarios like: Filtering data dynamically based on a list of values from an unrelated table...

Power BI DAX ACOT Function Description The ACOT function in Power BI DAX (Data Analysis Expressions) calculates the arc-cotangent (inverse cotangent) of a given number. It returns the angle (in radians) whose cotangent is the specified value. Syntax ACOT(number) number : A numeric value (real number) for which to calculate the arc-cotangent. Return Value Returns the arc-cotangent of the input number in radians , ranging from 0 to π (approximately 3.14159). Use Case The ACOT function is used in trigonometric calculations, particularly in scenarios involving angles and slopes. Common applications include: Engineering and Physics : Calculating angles in mechanical or structural designs where slopes or ratios are provided. Data Analysis : Analyzing geometric or spatial data, such as in geographic information systems (GIS). Financial Modeling : Used in niche cases involving ...