Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Material rodante

Hola, necesito calcular el material rodante para esto: la acción antes de Octubre/2019 es de 6314 euros el stock de octubre debe ser de 6314+ ENTRATE (octubre) - CHIUSE(octubre) stock d...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    6 years ago

    Hola @Mcarotenuto89 ,

    Puede crear una medida como se indica a continuación:

    Result =
VAR _ent =
    SUMX (
        FILTER (
            ALLSELECTED ( 'Test' ),
            'Test'[Date] <= MAX ( 'Date'[Mese-Anno] )
                && 'Test'[Date] >= DATE ( 2019, 10, 1 )
        ),
        [ENTRATE]
    )
VAR _chiu =
    SUMX (
        FILTER (
            ALLSELECTED ( 'Test' ),
            'Test'[Date] <= MAX ( 'Date'[Mese-Anno] )
                && 'Test'[Date] >= DATE ( 2019, 10, 1 )
        ),
        [CHIUSE]
    )
RETURN
    IF (
        MAX ( 'Date'[Mese-Anno] ) < DATE ( 2019, 10, 1 ),
        6314,
        6314 + ( _ent - _chiu )
    )

    Rolling stock.JPG

    Saludos

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

i used somenthing as you propose, the only problem is because i need to set as value only for october 3614+ the delta and after that the formula work perfectly , is t possible in BI?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

@Mcarotenuto89, puede agregar como

• [Fórmula antigua] + if(Max(Table[Month])-"Oct-2019", 3614, 0)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    stiil not working, i try to explain what i need in excel :

     

     

     

    ENTRATE, CHIUSE are measure

    Misura 3 is the delta of ENTRATE-CHIUSE

    Mese-Anno is 'Date table'[Mese-Anno]

     

     

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      6 years ago

      Hola @Mcarotenuto89 ,

      Puede crear una medida como se indica a continuación:

      Result =
VAR _ent =
    SUMX (
        FILTER (
            ALLSELECTED ( 'Test' ),
            'Test'[Date] <= MAX ( 'Date'[Mese-Anno] )
                && 'Test'[Date] >= DATE ( 2019, 10, 1 )
        ),
        [ENTRATE]
    )
VAR _chiu =
    SUMX (
        FILTER (
            ALLSELECTED ( 'Test' ),
            'Test'[Date] <= MAX ( 'Date'[Mese-Anno] )
                && 'Test'[Date] >= DATE ( 2019, 10, 1 )
        ),
        [CHIUSE]
    )
RETURN
    IF (
        MAX ( 'Date'[Mese-Anno] ) < DATE ( 2019, 10, 1 ),
        6314,
        6314 + ( _ent - _chiu )
    )

      Rolling stock.JPG

      Saludos

      Rena

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        thank you very much