Forum Discussion

carlwright1234's avatar
carlwright1234
New Member
5 years ago
Solved

Columna Promedio adicional

Hola Estoy tratando de agregar una columna Promedio adicional por mes a una nueva tabla como se muestra en la hoja de cálculo a continuación. Así que cada mes muestra las ventas mensuales, luego ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hola @carlwright1234 ,

    Compruebe la fórmula.

    Column = 
'Table'[2020 total]
    / CALCULATE (
        COUNTROWS (
            FILTER (
                UNION (
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Jan] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Feb] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Mar] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Apr] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-May] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Jun] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Jul] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Aug] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Sep] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Oct] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Nov] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Dec] )
                ),
                [value] <> BLANK ()
            )
        )
    )

    El resultado se mostraría como se muestra a continuación.

    1.PNG

    Saludos

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hola @carlwright1234 ,

Compruebe la fórmula.

Column = 
'Table'[2020 total]
    / CALCULATE (
        COUNTROWS (
            FILTER (
                UNION (
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Jan] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Feb] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Mar] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Apr] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-May] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Jun] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Jul] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Aug] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Sep] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Oct] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Nov] ),
                    SELECTCOLUMNS ( 'Table', "value", 'Table'[20-Dec] )
                ),
                [value] <> BLANK ()
            )
        )
    )

El resultado se mostraría como se muestra a continuación.

1.PNG

Saludos

Jay