Forum Discussion

Aileen167's avatar
Aileen167
New Member
3 years ago
Solved

problema con mes pasado

¡Hola Comunidad! Tengo un problema a la hora de ver el mes anterior, la idea de este código es que si estoy en enero que muestre la temporada de diciembre del año pasado. Intenté ocupando previous month o dateadd, sin embargo, no logré armar la formula. Actualmente este es la que estoy ocupando, pero tampoco funciona. ¡Agradecería su ayuda, Saludos!

IF (

    YEAR( Calendario[Date] ) = year(date(2023,01,15))

    && month (Calendario[Date] ) = month(date(2023,01,15))-1,

    1, if(

YEAR( Calendario[Date] ) = year(date(2023,01,15))-1

    && month (Calendario[Date] ) = month(date(2023,01,15))-(month(date(2023,01,15))-1),1,0)

)

(la fecha debería ser today(), pero estaba probando suponiendo que el mes fuera enero)

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Aileen167,

    I think it should relate to you extract the month number and minus it with 1. These conditions are equal to filter records who equal to current year and zero-month number. (this is an invalid date value)
    I'd like to suggest you directly move month transform calculations into the date function:

    formula =
VAR _cDate =
    DATE ( 2023, 01, 15 )
VAR _pDate =
    DATE ( YEAR ( _cDate ), MONTH ( _cDate ) - 1, DAY ( _cDate ) )
RETURN
    IF (
        YEAR ( Calendario[Date] ) = YEAR ( _cDate )
            && MONTH ( Calendario[Date] ) = 1,
        _pDate,
        _cDate
    )

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI Aileen167,

    I think it should relate to you extract the month number and minus it with 1. These conditions are equal to filter records who equal to current year and zero-month number. (this is an invalid date value)
    I'd like to suggest you directly move month transform calculations into the date function:

    formula =
VAR _cDate =
    DATE ( 2023, 01, 15 )
VAR _pDate =
    DATE ( YEAR ( _cDate ), MONTH ( _cDate ) - 1, DAY ( _cDate ) )
RETURN
    IF (
        YEAR ( Calendario[Date] ) = YEAR ( _cDate )
            && MONTH ( Calendario[Date] ) = 1,
        _pDate,
        _cDate
    )

    Regards,

    Xiaoxin Sheng

    • Aileen167's avatar
      Aileen167
      New Member
      3 years ago

      Muchas gracias! ahora que esta en date() retorna un 12

       

       

      flag =

      Var c_fecha= date(year (today()), Month (today())-1, Day(today()))
      Return
      IF (
      YEAR( Calendario[Date] ) = year(today())
      && month (Calendario[Date] ) =Month( c_fecha),
      1, 0
      )