Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Add 12 mobile months repeating empty data

Hello friends, good afternoon. I have the following problem, I need to generate a staff calculation of 12 mobile months projected until the end of the fiscal year (March 2023) but I have data onl...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    3 years ago

    Hello @Syndicate_Admin Rico Zhou

    I already found the solution:

    Headcount SSOMA=
    VAR _SUMMAIRZE =
        SUMMARIZE (
            'Calendar';
            Calendar[Date]. [Year];
            Calendar[Date]. [Month];
            "HEADCOUNT"; CALCULATE ( [NominaPropios] ))
    
    VAR _CIA = SELECTEDVALUE('Compañía'[EmpresaPivote])
    var FilterCia= IF(COUNTROWS(FILTERS('Compañía'[EmpresaPivote]))=1; FALSE(); TRUE())
    VAR VoF=IF(FilterCia=FALSE();_CIA; TRUE())
    VAR _ADD =
        ADDCOLUMNS (
            _SUMMAIRZE;
            "NewHeadCount";
                VAR _DATE =
                    MAXX ( ALL( NominaCons ); NominaCons[Periodo (fecha)] )
                VAR _LASTVALUE =
                    CALCULATE (
                        [NominaPropios];
                        all('NominaCons');
                        'NominaCons'[Periodo (fecha)] = _DATE;
                        'Compañía'[EmpresaPivote] IN VALUES('Compañía'[EmpresaPivote]);
                        TipoMineria[Tipo] IN VALUES(TipoMineria[Tipo]);
                        TipoNomina[TipoNomina] IN VALUES(TipoNomina[TipoNomina]);
                        BU[UNIDAD_DE_NEGOCIO] IN VALUES(BU[UNIDAD_DE_NEGOCIO])
                    )
                RETURN
                    IF ( ISBLANK ( [HEADCOUNT] ); _LASTVALUE; [HEADCOUNT] )
        )
    RETURN
        SUMX ( _ADD; [NewHeadCount] )