Daily DAX : Day 202 COS

 The COS function in Power BI DAX (Data Analysis Expressions) calculates the cosine of a given angle, where the angle is specified in radians. It is a mathematical and trigonometric function commonly used in calculations involving periodic phenomena, geometry, or wave-like patterns.

Syntax

dax


COS(number)


    number: The angle in radians for which you want to calculate the cosine. This can be a numeric value, a column, or an expression that evaluates to a number.


Return Value

The function returns the cosine of the specified angle, which is a value between -1 and 1.

Key Points


    If the input is not in radians, you must convert it using the RADIANS function or by multiplying degrees by PI()/180.

    The COS function is often used in combination with other trigonometric functions like SIN, TAN, or ACOS for advanced calculations.

    It is useful in scenarios involving angles, rotations, or oscillatory data.


Use Case Example

Suppose you are analyzing data related to a mechanical system or a dataset with angular measurements (e.g., a rotating wheel or a pendulum). You might use the COS function to calculate the horizontal component of motion or to model periodic behavior.

Scenario: Calculating the X-Coordinate of a Rotating Object

You have a table in Power BI with a column AngleDegrees containing angles in degrees for a rotating object. You want to calculate the x-coordinate of the object on a circular path with a radius of 10 units.


    Convert Degrees to Radians:

    Since the COS function requires radians, convert the angle using the RADIANS function or manually.

    DAX Formula:

    Create a calculated column or measure to compute the x-coordinate:

    dax


    XCoordinate = 10 * COS(RADIANS('Table'[AngleDegrees]))


    Explanation:

        RADIANS('Table'[AngleDegrees]) converts the angle from degrees to radians.

        COS(...) computes the cosine of the angle.

        Multiplying by 10 (the radius) gives the x-coordinate of the object on the circular path.

    Visualization:

    You can use this calculated column in a Power BI visual (e.g., a scatter plot) to show the position of the object over time or angle.


Practical Applications


    Engineering: Calculate positions or forces in systems with rotational or oscillatory motion (e.g., robotics, turbines).

    Data Science: Model seasonal or cyclic patterns in time-series data (e.g., sales cycles, temperature variations).

    Geospatial Analysis: Compute coordinates or distances in circular or spherical systems.

    Physics Simulations: Simulate wave patterns or harmonic motion in dashboards.


Example with Sample Data

Assume a table with the following data:

AngleDegrees

0

90

180

270

Create a calculated column:

dax


CosineValue = COS(RADIANS('Table'[AngleDegrees]))


Results:

AngleDegrees            CosineValue

0                                    1

90                                  0

180                                -1

270                                 0

Notes


    If you need to work with degrees directly, ensure proper conversion to radians.

    For inverse cosine calculations, use the ACOS function.

    Be cautious with null or invalid inputs, as they may cause errors in calculations.


For more details, refer to the official DAX documentation: COS function.

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