Component.Pluralization

Handle singular/plural text based on numeric values. Returns appropriate text form depending on count.

Syntax

DaxLib.FormatString.Component.Pluralization ( value, singular_text, plural_text )

Definition

DAX 
// Handle pluralization based on count values
// Returns singular or plural forms like "1 item" vs "2 items"
(
    // Count value
    count_reference: NUMERIC,

    // Singular form (e.g., "item")
    singular: STRING,

    // Plural form (e.g., "items")
    plural: STRING
) =>
    VAR _Word = IF( ABS( count_reference ) = 1, singular, plural )

    RETURN
        FORMAT( count_reference, "#,##0" ) & " " & _Word

Parameters

Parameter Type Description
value NUMBER Numeric value to evaluate for pluralization
singular_text STRING Text to use for singular form (value = 1)
plural_text STRING Text to use for plural form (value ≠ 1)

Example

DaxLib.FormatString.Component.Pluralization ( 1, "item", "items" )

Use this function to handle singular/plural text forms based on numeric values.

Related Functions