Forum Discussion

ForzaMami's avatar
ForzaMami
Regular Visitor
4 years ago

one top row data

It's a little hard to explain, I need to use the same formula in a single dax formula, the one in the top row. I'm trying to power the "Exponential Smoothing" column in the excel below. Is something ...
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi ForzaMami 

you may try

 

Exponential Smoothing =
VAR CurrentYearMonth =
    MAX ( Table[Year_Month] )
VAR PreviousStatus1 =
    CALCULATE ( [Status], Table[Year_Month] = CurrentYearMonth - 100 )
VAR PreviousStatus2 =
    CALCULATE ( [Status], Table[Year_Month] = CurrentYearMonth - 200 )
RETURN
    IF (
        NOT ISBLANK ( PreviousStatus1 ) && NOT ISBLANK ( PreviousStatus2 ),
        IF (
            ISBLANK ( PreviousStatus1 ),
            PreviousStatus2,
            0.5 * PreviousStatus1 + 0.5 * PreviousStatus2
        )
    )

 

  • ForzaMami's avatar
    ForzaMami
    Regular Visitor
    4 years ago

    Hi,

     

    Dont work. If you want to get the 1st and 2nd months retrospectively, it doesn't work either.

     

     

     

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      ForzaMami 

      Can you please right the expected results with explanation in this same screenshot?

      • ForzaMami's avatar
        ForzaMami
        Regular Visitor
        4 years ago

        Hi ,

         

         

         

        Exponential_1 =
        ([Input2Values]*[Measure Last Period]) + ([Input2Values] * [Measure Last Period](Wrong) )
         
        20200301 = (0,5*633.973) + ( 0,5*4.076.361 ) = 2.355.167 must
        20200401 = (0,5*766.859) + ( 0,5*2.355.167 )= 1.561.013 must