Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Error con función Switch

Estoy teniendo problemas con la función switch Necesito agregar una columna con fórmula y que haga: Si en la columna "semana" dice "Semana 1" y en la columna "mes" dice 4, entonces en la columna ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    You can create two calculated columns as below to get the expected result:

    Column = 
SWITCH (
    TRUE (),
    'Tabla'[mes] = 4,
        14 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1,
    'Tabla'[mes] = 5,
        18 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1,
    'Tabla'[mes] = 6,
        23 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1,
    'Tabla'[mes] = 8,
        30 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1
)
    Weeknum = 
IF (
    ISBLANK ( Tabla[Column] ),
    IF (
        'Tabla'[Atributo] = "Semana 4",
        29,
        IF (
            'Tabla'[Atributo] = "Semana 5",
            30,
            27 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1
        )
    ),
    [Column]
)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

You can create two calculated columns as below to get the expected result:

Column = 
SWITCH (
    TRUE (),
    'Tabla'[mes] = 4,
        14 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1,
    'Tabla'[mes] = 5,
        18 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1,
    'Tabla'[mes] = 6,
        23 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1,
    'Tabla'[mes] = 8,
        30 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1
)
Weeknum = 
IF (
    ISBLANK ( Tabla[Column] ),
    IF (
        'Tabla'[Atributo] = "Semana 4",
        29,
        IF (
            'Tabla'[Atributo] = "Semana 5",
            30,
            27 + VALUE ( RIGHT ( 'Tabla'[Atributo], 1 ) ) - 1
        )
    ),
    [Column]
)

Best Regards